Re: php4 / pgsql7 problem (too many clients)

someone had mentioned before that persistent connections don't work so well
in PHP.  It doesn't do a very good job of releasing them... so eventually it
fills up.  The solutions are either to restart the postmaster when it
happens or don't code persistent connections.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Pascal Jolin" <pjolin@e-c.qc.ca>
To: <pgsql-php@postgresql.org>
Sent: Friday, October 27, 2000 2:40 PM
Subject: php4 / pgsql7 problem (too many clients)


> I recently started getting this message on a pgsql7 / php4 installation:
>
>
>  Warning: Unable to connect to PostgresSQL server: Sorry, too many clients
>  already in /usr/local/lib/php/phplib-7.2/php/db_pgsql.inc on line 40
>  Database error: Link-ID == false, pconnect failed
>  PostgreSQL Error: 0 ()
>  Session halted.
>
>  I've been unable to locate the source of this error, or any pertinent
info
>  about the default number of client connections allowed, and/or how to
> change
>  it.
>
>  Can anyone point me in the right direction please ?
>
>
>