X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3A4F43AC10F for ; Wed, 29 Dec 2004 15:05:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23601-05 for ; Wed, 29 Dec 2004 15:05:17 +0000 (GMT) Received: from localnotion.com (localnotion.com [200.46.204.32]) by svr1.postgresql.org (Postfix) with ESMTP id 3BFFE3AC09B for ; Wed, 29 Dec 2004 15:05:19 +0000 (GMT) Received: from [192.168.2.18] (ool-182c7886.dyn.optonline.net [24.44.120.134]) by localnotion.com (Postfix) with ESMTP id 15B4E667336 for ; Wed, 29 Dec 2004 15:05:18 +0000 (GMT) Mime-Version: 1.0 (Apple Message framework v619) Content-Transfer-Encoding: 7bit Message-Id: <0DC9A380-59AB-11D9-B3B3-0003938BDF32@localnotion.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-php@postgresql.org From: Matthew Terenzio Subject: too many clients Date: Wed, 29 Dec 2004 10:05:18 -0500 X-Mailer: Apple Mail (2.619) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/1 X-Sequence-Number: 2959 After years of running apache-php-postgres with no issues, I'm suddenly receiving the cannot connect to postgres - too many clients already error on my script pages. 1. Does everyone ALWAYS have Apache max connections lower than postgres max clients? I tried this but the problem still returned. 2.I'm using pg_pconnect(). 3. Traffic is slightly higher lately but not that high. 4. I'm thinking about apache changing apache maxrequestsperchild from 0 to maybe 10 or something to periodically kill apache children, but I can't see why the maxclients in apache would overload postgres if they are both the same number. It is hard fro me to believe there are actually that many simultaneous users of this system, so for some reason the connections are remaining open and unused. Any wisdom out there? Matt