[Zope] Zope-2.6 + PostgreSQL-7.2.1 + ZPsycopgDA

Dieter Maurer dieter@handshake.de
Fri, 20 Dec 2002 21:07:39 +0100


Thierry Florac writes:
 > I currently use the products described in the title on a Linux server.
 > 
 > My problem is that as the site is used (even by a little number of
 > users), more and more connections are opened on the PostgreSQL server.
 > But these connections are not released, even if many of them don't seem
 > to be reused, and after a while PostgreSQL refuse new connections saying
 > that too many connections are already open.
 > 
 > Is there any way to handle such a kind of problems in Zope, to reuse or
 > close existing connections when no more used, or is it only a PostgreSQL
 > problem ???
We have had this problem with on older version of "Psycopg/ZPsycopg".

It seems to have gone away after an upgrade, though we are not yet
sure (We upgraded several month before and we have had a single
"too many clients" problem since then, whiler formerly, we
had regular problems of this kind).



Dieter