Re: How does server handle clients that disconnect ungracefully?

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...

--- Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>