Re: hung postmaster when client machine dies? - Mailing list pgsql-admin

Jeff <threshar@torgo.978.org> writes:
> Eventually PG would have found out the socket was dead.

We do enable TCP keepalive on the client socket, so eventually the
kernel will time out and notify us of a lost connection.  Unfortunately
the timeouts involved are long --- IIRC the relevant RFCs specify at
least an hour.

            regards, tom lane