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

From Magnus Hagander
Subject Re: How does server handle clients that disconnect ungracefully?
Date
Msg-id 20070424140140.GF15856@svr2.hagander.net
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?  (Jeff Lanzarotta <delux256-postgresql@yahoo.com>)
List pgsql-general
On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
> OK, thanks. I figured the server would at some point in time clear the
> connection up, my question now is when does that happen? Any idea how
> long the connection sit around before the server cleans it up? Someone
> else said possibly an hour...

Depends on yuor OS - when the TCP connection times out, PostgreSQL will
clean up and terminate the backup.

//Magnus


pgsql-general by date:

Previous
From: "Marcelo de Moraes Serpa"
Date:
Subject: Audit-trail engine: getting the application's layer user_id
Next
From: Kevin Murphy
Date:
Subject: Re: Building PG 8.2.3 for x86_64 on Mac OS X 10.4.9