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(at)rutgersinsurance(dot)com>
To: <pgsql-php(at)postgresql(dot)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(at)e-c(dot)qc(dot)ca>
> To: <pgsql-php(at)postgresql(dot)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 ?
> >
> >
> >
>
>