Received: from fisicc-ufm.edu ([216.230.140.135]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UEwQC31898 for ; Mon, 30 Oct 2000 09:58:27 -0500 (EST) (envelope-from rocket@mailhub.fisicc-ufm.edu) Received: (from nobody@localhost) by fisicc-ufm.edu (8.9.3/8.9.3) id IAA89644; Mon, 30 Oct 2000 08:57:00 -0600 (CST) (envelope-from rocket@mailhub.fisicc-ufm.edu) Date: Mon, 30 Oct 2000 08:57:00 -0600 (CST) From: Rodrigo Fernandez Message-Id: <200010301457.IAA89644@fisicc-ufm.edu> X-Authentication-Warning: mailhub.fisicc-ufm.edu: nobody set sender to rocket@mailhub.fisicc-ufm.edu using -f To: pgsql-php@postgresql.org Errors-To: rocket@fisicc-ufm.edu Reply-To: rocket@fisicc-ufm.edu MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: IMP/PHP3 Imap webMail Program 2.0.2 X-Originating-IP: 216.230.142.66 Subject: Dirigir a: Re: php4 / pgsql7 problem (too many clients) X-Archive-Number: 200010/6 X-Sequence-Number: 6 > 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/