Tom Lane writes:
> There is something wrong with your system, not with Postgres. Any
> reasonable TCP stack will time out within circa 1 minute if no response.
>
> Example (sss is a machine on my LAN that's not presently up):
>
> $ time psql -h sss
> psql: PQconnectPoll() -- connect() failed: Connection timed out
> Is the postmaster running (with -i) at 'sss'
> and accepting connections on TCP/IP port '5432'?
>
> real 1m14.27s
> user 0m0.01s
> sys 0m0.01s
> $
>
> This particular timeout length is probably specific to HPUX, but the
> point is that you have a local system problem.
I can observe something peculiar:
With current sources:
peter ~$ time pg-install/bin/psql -h ralph
psql: could not connect to server: No route to host Is the server running on host ralph and accepting
TCP/IPconnections on port 5432?
real 0m3.013s
user 0m0.010s
sys 0m0.010s
With 7.0.2:
peter ~$ time psql -h ralph
psql: PQconnectPoll() -- connect() failed: No route to host Is the postmaster running (with -i) at 'ralph'
andaccepting connections on TCP/IP port '5432'?
[hangs]
The backtrace shows:
#0 0x401d9a0e in __select () from /lib/libc.so.6
#1 0x4002f3b0 in b2c3 () from /usr/lib/libpq.so.2.1
#2 0x4002666e in pqFlush () from /usr/lib/libpq.so.2.1
#3 0x40022bc2 in closePGconn () from /usr/lib/libpq.so.2.1
#4 0x40022c67 in PQfinish () from /usr/lib/libpq.so.2.1
#5 0x805167d in main ()
I suspect that this may be because of the questionable TCP implementation
in Linux that you argued about with Alan Cox et al. a while ago, though I
don't pretend to fathom the details. Apparently something in libpq
changed in between, however.
But that reinforces your point that "something is wrong with your system".
;-)
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
