Re: hung postmaster when client machine dies?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: Mark Harrison <mh(at)pixar(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: hung postmaster when client machine dies?
Date: 2004-01-30 15:42:08
Message-ID: 13921.1075477328@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jeff <threshar(at)torgo(dot)978(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Goulet, Dick 2004-01-30 15:42:42 Re: hung postmaster when client machine dies?
Previous Message Larry Rosenman 2004-01-30 15:19:24 Re: Veritas Filesystem