Idle connections - Too many clients connected already

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Idle connections - Too many clients connected already
Date: 2004-01-21 13:50:09
Message-ID: 6C0CF58A187DA5479245E0830AF84F42080198@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

After using Postgresql for a while, through ODBC / MS Access, I'm not
able to connect to the server anymore. The server reports "Too many
clients connected already".

With a "ps -afx", I can see a lot of idle postgresql connections, which
correspond for sure to ODBC connections that haven't been closed
properly, and that remain opened. Stopping and restarting the server
solves the problem.

Is there a way to avoid that? I cannot certifiy that clients will always
close their connexions in a clean way. So, is the server able to check
if clients are still alive, and close their connexion if it's not the
case? I never had anything like that with MS SQL Server...

Thanks

Philippe

Browse pgsql-general by date

  From Date Subject
Next Message Alex Madon 2004-01-21 14:11:38 postgresql + apache under heavy load
Previous Message Harald Fuchs 2004-01-21 13:24:42 Re: SCO Extortion