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?). Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
