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 13:43:34
Message-ID: 20070424134334.GD15856@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 24, 2007 at 05:53:02AM -0700, Jeff Lanzarotta wrote:
> Hello,
>
> I am writing an application that reads information from my PostgreSQL
> database. If I cause the program to crash and the program ends without
> gracefully disconnecting from the database, there is an open connection
> still left in the database.
>
> How does the PostgreSQL server handle clients that disconnect
> ungracefully? Will the server automatically clean up this connection
> that really is not there?

Yes, but it will log a notice about it in the server log.

//Magnus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-04-24 13:45:46 Re: How does server handle clients that disconnect ungracefully?
Previous Message Richard Huxton 2007-04-24 13:41:55 Re: Problem Backing Up a DB