Re: php4 / pgsql7 problem (too many clients)

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" <aalang@rutgersinsurance.com>
To: <pgsql-php@postgresql.org>
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" <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 ?
> >
> >
> >
>
>