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

From Jeff Lanzarotta
Subject Re: How does server handle clients that disconnect ungracefully?
Date
Msg-id 592925.70180.qm@web36809.mail.mud.yahoo.com
Whole thread Raw
In response to Re: How does server handle clients that disconnect ungracefully?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: How does server handle clients that disconnect ungracefully?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
OK, that is what the other fellow said... It depends on the TCP/IP
stack...

Thanks again for the clarification.

--- Magnus Hagander <magnus@hagander.net> wrote:

> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: Re: Building PG 8.2.3 for x86_64 on Mac OS X 10.4.9
Next
From: Richard Huxton
Date:
Subject: Re: Problem Backing Up a DB