Re: How does server handle clients that disconnect ungracefully?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Jeff Lanzarotta <delux256-postgresql(at)yahoo(dot)com>
Cc: PostgreSQL GENERAL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: How does server handle clients that disconnect ungracefully?
Date: 2007-04-24 14:01:40
Message-ID: 20070424140140.GF15856@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2007-04-24 14:12:51 Re: Building PG 8.2.3 for x86_64 on Mac OS X 10.4.9
Previous Message Marcelo de Moraes Serpa 2007-04-24 13:56:23 Audit-trail engine: getting the application's layer user_id