From: Mitch Vincent <mitch@venux.net>
To: pgsql-php@postgresql.org
Subject: Re: php4 / pgsql7 problem (too many clients)
Date: Fri, 27 Oct 2000 13:37:27 -0700
Message-ID: <00bc01c04055$bb4d0a40$0200000a@doot> (raw)
References: <006d01c04045$69b75ec0$c2092fce@pascal>
<004601c0404f$bc372ae0$330a0a0a@6014cwpza006>
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 ?
> >
> >
> >
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: mitch@venux.net
Subject: Re: php4 / pgsql7 problem (too many clients)
In-Reply-To: <00bc01c04055$bb4d0a40$0200000a@doot>
References: <006d01c04045$69b75ec0$c2092fce@pascal> <004601c0404f$bc372ae0$330a0a0a@6014cwpza006> <00bc01c04055$bb4d0a40$0200000a@doot>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox