Re: Suggestion for To Do List - Client timeout please.

Grant <grant@conprojan.com.au> writes:
> Possibly create a timeout for psql. pg_dump, pg_restore and other clients.
> If they can not connect to a certain host within a certain period it will
> quit with an error. I have psql's still running for 6 days from crontab
> that could not connect to a bogus IP address.

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.
        regards, tom lane