| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Trevor Talbot <quension(at)gmail(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql hanging |
| Date: | 2007-09-05 20:06:48 |
| Message-ID: | 20070905200648.GA11604@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ottó Havasvölgyi | 2007-09-05 20:31:11 | now() vs current_user |
| Previous Message | Scott Marlowe | 2007-09-05 19:39:13 | Re: UTF8 frustrations |