|
|
|
|
|
|
| Author |
Message |
Reid Thompson
*nix forums beginner
Joined: 12 May 2005
Posts: 41
|
 Posted: Tue Jul 18, 2006 8:26 pm Post subject:
postmaster: StreamConnection: accept: No such device or address
|
|
|
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get "no connection to server" errors from ecpg
programs ( which I believe are probably due to the same issud ).
Can anyone shed some light on what could be causing this? OS resource
limitation? Known bug in ancient version of PG?
thanks,
reid
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |
|
| Back to top |
|
 |
Larry Rosenman
*nix forums addict
Joined: 05 Feb 2005
Posts: 72
|
| Posted: Tue Jul 18, 2006 8:36 pm Post subject:
Re: postmaster: StreamConnection: accept: No such device or address
|
|
|
Reid Thompson wrote:
| Quote: | Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get "no connection to server" errors from ecpg
programs ( which I believe are probably due to the same issud ).
Can anyone shed some light on what could be causing this? OS resource
limitation? Known bug in ancient version of PG?
thanks,
reid
|
Is something cleaning /tmp of the unix socket? Older versions didn't keep
the
timestamp updated, and /tmp cleaning utilities could remove the socket.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend |
|
| Back to top |
|
|
Reid Thompson
*nix forums beginner
Joined: 12 May 2005
Posts: 41
|
| Posted: Tue Jul 18, 2006 11:10 pm Post subject:
Re: postmaster: StreamConnection: accept: No such device
|
|
|
Larry Rosenman wrote:
| Quote: | Reid Thompson wrote:
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get "no connection to server" errors from ecpg
programs ( which I believe are probably due to the same issud ).
Can anyone shed some light on what could be causing this? OS resource
limitation? Known bug in ancient version of PG?
thanks,
reid
Is something cleaning /tmp of the unix socket? Older versions didn't keep
the
timestamp updated, and /tmp cleaning utilities could remove the socket.
The errors occur when psql is used with -h also, and the ecpg program is |
connecting from a different host.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Mon Dec 01, 2008 9:33 pm | All times are GMT
|
|
Property in Spain | Per Insurance | Watch Anime Online | Credit Cards | Ringtones
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
