From: Rodrigo Fernandez <rocket@fisicc-ufm.edu>
To: pgsql-php@postgresql.org
Subject: Dirigir a: Re: php4 / pgsql7 problem (too many clients)
Date: Mon, 30 Oct 2000 08:57:00 -0600 (CST)
Message-ID: <200010301457.IAA89644@fisicc-ufm.edu> (raw)
> 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 ?
>
>
>
I had the same problem, I did 3 things to \"solve\" the problem:
1.- edit the php.ini to fine tune the numper of persistent connections.
(note that this are persistent connections per script, it is not the
global number of persistent connections for all scripts).
2.- get more memory for my computer (persistent connections tend to
take a lot of memory).
3.- fine tune the \"MaxRequestsPerChild\" variable in the httpd.conf, which
controls the number of request a httpd child will accept before y dies
and takes all the persistent connections with it. This will mantain
a balance in the number of open persisten connections.
Hope to help you...
Rodrigo F.
-----------------------------------------------------
This mail sent through IMP: http://web.horde.org/imp/
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: rocket@fisicc-ufm.edu
Subject: Re: Dirigir a: Re: php4 / pgsql7 problem (too many clients)
In-Reply-To: <200010301457.IAA89644@fisicc-ufm.edu>
References: <200010301457.IAA89644@fisicc-ufm.edu>
* 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