pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedphp4 / pgsql7 problem (too many clients)
4+ messages / 4 participants
[nested] [flat]
* php4 / pgsql7 problem (too many clients)
@ 2000-10-27 18:40 Pascal Jolin <pjolin@e-c.qc.ca>
2000-10-27 19:54 ` Re: php4 / pgsql7 problem (too many clients) Adam Lang <aalang@rutgersinsurance.com>
2000-10-27 21:10 ` Re: php4 / pgsql7 problem (too many clients) Stephen van Egmond <svanegmond@bang.dhs.org>
0 siblings, 2 replies; 4+ messages in thread
From: Pascal Jolin @ 2000-10-27 18:40 UTC (permalink / raw)
To: pgsql-php
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 ?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: php4 / pgsql7 problem (too many clients)
2000-10-27 18:40 php4 / pgsql7 problem (too many clients) Pascal Jolin <pjolin@e-c.qc.ca>
@ 2000-10-27 19:54 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-27 20:37 ` Re: php4 / pgsql7 problem (too many clients) Mitch Vincent <mitch@venux.net>
1 sibling, 1 reply; 4+ messages in thread
From: Adam Lang @ 2000-10-27 19:54 UTC (permalink / raw)
To: pgsql-php
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 ?
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: php4 / pgsql7 problem (too many clients)
2000-10-27 18:40 php4 / pgsql7 problem (too many clients) Pascal Jolin <pjolin@e-c.qc.ca>
2000-10-27 19:54 ` Re: php4 / pgsql7 problem (too many clients) Adam Lang <aalang@rutgersinsurance.com>
@ 2000-10-27 20:37 ` Mitch Vincent <mitch@venux.net>
0 siblings, 0 replies; 4+ messages in thread
From: Mitch Vincent @ 2000-10-27 20:37 UTC (permalink / raw)
To: pgsql-php
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 ?
> >
> >
> >
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: php4 / pgsql7 problem (too many clients)
2000-10-27 18:40 php4 / pgsql7 problem (too many clients) Pascal Jolin <pjolin@e-c.qc.ca>
@ 2000-10-27 21:10 ` Stephen van Egmond <svanegmond@bang.dhs.org>
1 sibling, 0 replies; 4+ messages in thread
From: Stephen van Egmond @ 2000-10-27 21:10 UTC (permalink / raw)
To: Pascal Jolin <pjolin@e-c.qc.ca>; +Cc: pgsql-php
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-10-27 21:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-27 18:40 php4 / pgsql7 problem (too many clients) Pascal Jolin <pjolin@e-c.qc.ca>
2000-10-27 19:54 ` Adam Lang <aalang@rutgersinsurance.com>
2000-10-27 20:37 ` Mitch Vincent <mitch@venux.net>
2000-10-27 21:10 ` Stephen van Egmond <svanegmond@bang.dhs.org>
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