close inactive client connection

From: "Luiz Bernardi" <lb(at)cplinformatica(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: close inactive client connection
Date: 2009-09-25 13:47:30
Message-ID: web-7618249@hm775.cl01.mobimail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Bernardi
Fone 41 36755756
     41 99979849

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-09-25 14:12:22 Re: ERROR: invalid input syntax for integer: ""
Previous Message Jaromír Talíř 2009-09-25 12:39:36 Re: lazy vacuum and AccessExclusiveLock