[Pgpool-general] one has no free connection, but another has an idle one

Stefan Hans shans at tanagra.de
Mon Feb 21 18:35:10 GMT 2005


Hello *,

I have installed php and postgres at the moment and there is the following problem:

Let's say we have max_connections 100 and two users; one has 50 used connections (pg_pconnect) and want to get a new one. The other user has 50 connections and some of these are idle. PHP will send an error message "no new connection possible".

Is it possible that pg_pool takes one idle connection from one user and give a new one to the other?

Thx in advance

Stefan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20050221/689e6a2d/attachment.html


More information about the Pgpool-general mailing list