X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 33234534CA for ; Mon, 11 Apr 2005 18:56:44 -0300 (ADT) 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 89015-09 for ; Mon, 11 Apr 2005 21:56:42 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id AE459533F5 for ; Mon, 11 Apr 2005 18:56:40 -0300 (ADT) Received: (qmail 10808 invoked from network); 11 Apr 2005 21:56:43 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.22?) (64.3.242.80) by 0 with SMTP; 11 Apr 2005 21:56:43 -0000 In-Reply-To: <63e99d37aa5bcac9a9045bca674060e6@elma.fr> References: <63e99d37aa5bcac9a9045bca674060e6@elma.fr> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Message-Id: <16fdb7fc4e8c15ab40acc2540143fe4c@sitening.com> Content-Transfer-Encoding: quoted-printable Cc: pgsql-admin@postgresql.org From: Thomas F.O'Connell Subject: Re: Limited to 100 connections Date: Mon, 11 Apr 2005 16:56:42 -0500 To: fred X-Mailer: Apple Mail (2.619.2) 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: 200504/143 X-Sequence-Number: 17156 max_connections is a setting that can only be set at server start. Are=20= you restarting postgres after you change the setting in=20 postgresql.conf? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i=99 http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Apr 7, 2005, at 5:52 PM, fred wrote: > Hi, > I'm using Postgres on MacOS X 10.3 and I'm limited to 100 connections. > In the postgres.conf, I set max_connections to 300, but I'm always=20 > limited to 100 connections. > I also increased the SHM_MAX to 400 Megs > > I connect to my database using PHP scripts and pg_pconnect. > > If anyone got an idea, I'll take it > > Thanks > > Fred=