close inactive client connection - Mailing list pgsql-general

From Luiz Bernardi
Subject close inactive client connection
Date
Msg-id web-7612005@hm775.cl01.mobimail.com
Whole thread Raw
Responses Re: close inactive client connection  (John R Pierce <pierce@hogranch.com>)
Re: close inactive client connection  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Hello,


 I am developing a system, using the ZeosLib, which maintains a permanent connection to the database.


 When the client loses the connection, the server does
not recognize this and keeps the connection as if it were active. When
the client attempts to reconnect, the server creates a new connection
and the previous remains active.
 This has caused an excessive increase in the number of active connections and hampered the use of the system.


 Have any way or setting to make postgres close idle connections?
--
Luiz Agnaldo BernardiFone 41
36755756     41 99979849

pgsql-general by date:

Previous
From: Jaromír Talíř
Date:
Subject: Re: lazy vacuum and AccessExclusiveLock
Next
From: "Luiz Bernardi"
Date:
Subject: close inactive client connection