Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.10.1/8.11.0) with ESMTP id e9RKX7Z90055 for ; Fri, 27 Oct 2000 16:33:08 -0400 (EDT) (envelope-from mitch@venux.net) Received: from doot (cx853045-b.phnx1.az.home.com [24.177.75.28]) by icebox.venux.net (Postfix) with SMTP id 3AD332620B for ; Fri, 27 Oct 2000 16:43:06 -0400 (EDT) Message-ID: <00bc01c04055$bb4d0a40$0200000a@doot> From: "Mitch Vincent" To: References: <006d01c04045$69b75ec0$c2092fce@pascal> <004601c0404f$bc372ae0$330a0a0a@6014cwpza006> Subject: Re: php4 / pgsql7 problem (too many clients) Date: Fri, 27 Oct 2000 13:37:27 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Archive-Number: 200010/49 X-Sequence-Number: 64 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" To: 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" > To: > 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 ? > > > > > > > >