Search Postgresql Archives

Re: How does server handle clients that disconnect ungracefully?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx so that
> your
>        message can get through to the mailing list cleanly
> 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux