Re: How does server handle clients that disconnect ungracefully? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: How does server handle clients that disconnect ungracefully?
Date
Msg-id 20070424153902.GE2579@svana.org
Whole thread Raw
In response to Re: How does server handle clients that disconnect ungracefully?  (Jeff Lanzarotta <delux256-postgresql@yahoo.com>)
Responses Re: How does server handle clients that disconnect ungracefully?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Apr 24, 2007 at 07:16:38AM -0700, Jeff Lanzarotta wrote:
> OK, that is what the other fellow said... It depends on the TCP/IP
> stack...
>
> Thanks again for the clarification.

Note, there are two cases. If only the program crashes but the system
is fine, the kernel will close the socket for you straight away and the
server with notice the hangup.

The only time the server will wait for a time out is if the server and
the client are on different machines and something disrupts actual
communications. If the client machine crashes without notifying the
server, or someone pulls out a network cable. If the client and the
server are on the same machine, it will always notice.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "Andy Dale"
Date:
Subject: Generic triggers ?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Generic triggers ?