php4 / pgsql7 problem (too many clients)
php4 / pgsql7 problem (too many clients)
От:
"Pascal Jolin" <pjolin@e-c.qc.ca>
Дата:
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 ?
Re: php4 / pgsql7 problem (too many clients)
От:
"Adam Lang" <aalang@rutgersinsurance.com>
Дата:
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" To: 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 ? > > >
Re: php4 / pgsql7 problem (too many clients)
От:
"Mitch Vincent" <mitch@venux.net>
Дата:
It might have been me that mentioned the problems with persistent connections and PHP -- I've been trying to track down the bug(s) for about a year now (off and on).. It seems it's better but I find it rears it's ugly head every few months.. I don't see the too many clients error but I do see very strange happenings with the basic functions (queries returning empty sets when they should etc..).. I'm pretty sure it's a problem in the PHP module, not PostgreSQL but I haven't been able to prove it either way yet. The overhead on my production machines is minimal to start up a backend for each connection, it really hasn't become a problem yet and some of my production servers are hit pretty hard.. Good luck!! -Mitch ----- Original Message ----- From: "Adam Lang" To: Sent: Friday, October 27, 2000 12:54 PM Subject: 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" > To: > 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 ? > > > > > > > >
Re: php4 / pgsql7 problem (too many clients)
От:
Stephen van Egmond <svanegmond@bang.dhs.org>
Дата:
Pascal Jolin (pjolin@e-c.qc.ca) wrote: > 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. php will limit the number of simultaneous connections to postgresql. Look in your php.ini (debian: /etc/php4/apache/php.ini) and find pgsql.max_persistent This may also be limited by pgsql -- look at pg_options.