Re: [SQL] Unclosed connections - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: [SQL] Unclosed connections
Date
Msg-id dcc563d10801250819h2260eafbl8f56b65b979b6c7d@mail.gmail.com
Whole thread Raw
In response to Unclosed connections  (PostgreSQL Admin <postgres@productivitymedia.com>)
List pgsql-admin
On Jan 25, 2008 10:02 AM, PostgreSQL Admin
<postgres@productivitymedia.com> wrote:
> We are using this bad piece of the software that does not close
> connections to the postgres server.  Is there some setting for closing
> dead connections? And not TCP/IP keep alive does not work.

If the TCP keepalive can't detect them as dead, how is something else
supposed to?  I.e. if a keepalive packet gets answered, then the
connection isn't dead, something is still connected to it.

pgsql-admin by date:

Previous
From: PostgreSQL Admin
Date:
Subject: Unclosed connections
Next
From: Steven Rosenstein
Date:
Subject: Recovering a database in danger of transaction wrap-around