On 9/5/07, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote: > On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote: > > Unless psql is turning on keepalive or similar, or the OS is forcing > > it on by default, there are no timeouts for idle TCP connections. If > > the command was transported to the server successfully and psql was > > just waiting for a result, the connection is idle and nothing will > > happen if the server end suddenly goes away. > > Well, any TCP implementation has to support keepalives and generally > they are turned on by default, but to something like 2 days. Anything > months old must be caused by something else (overzealous firewall > dropping the RST packets in response to the keepalives?). The default for RHEL3 and 4 is 2 hours. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
