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 9D4885653D for ; Tue, 8 Mar 2005 05:41:44 +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 50430-01 for ; Tue, 8 Mar 2005 05:41:34 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 4F3E8563EF for ; Tue, 8 Mar 2005 05:41:33 +0000 (GMT) Received: (qmail 22734 invoked from network); 8 Mar 2005 05:41:32 -0000 Received: from host-209.149.56.238.nashville.net (HELO ?10.0.1.2?) (209.149.56.238) by 0 with SMTP; 8 Mar 2005 05:41:32 -0000 In-Reply-To: <003101c52316$bd8e4f00$8c0aa8c0@rram> References: <003101c52316$bd8e4f00$8c0aa8c0@rram> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <93dd2f9da9397187a135f96b5f607c75@sitening.com> Content-Transfer-Encoding: quoted-printable Cc: From: Thomas F.O'Connell Subject: Re: Too many clients----A big problem for my team Date: Mon, 7 Mar 2005 23:41:31 -0600 To: "ganapatiram" X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/111 X-Sequence-Number: 16609 Well, first of all, max_connections can only be set at server start.=20 Are you restarting postgres when you do "trial and error changes"? Secondly, 5 users can still manage to make multiple connections. You=20 can use ps to see how many connections are active at any given time. http://www.postgresql.org/docs/8.0/static/monitoring.html#MONITORING-PS -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 7, 2005, at 7:08 AM, ganapatiram wrote: > Hi Experts, > =A0 > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 I work with postgresql 8.0 version. I = have a team of 14=20 > developers. When all the team connects the DB i see this error very=20 > very frequently which is a severe problem for me and team all the day.=20= > The error is: > =A0 > > Please report this exception: java.sql.SQLException: FATAL:=A0 sorry,=20= > too many clients already > > =A0 > > when i do trial and error changes i see this error differently but the=20= > essense of the error remains same. > > =A0 > > =A0=A0=A0 =A0=A0=A0 I have max_connections=3D200 and i have 5 users = for my DB. I=20 > dont understand what to do in order to resolve this. Please suggest me=20= > something by which i can overcome this problem. I referred few threads=20= > but none of them are of my case. > > =A0 > > =A0 > > Waiting for your valuable suggestion.......... > > =A0 > > =A0 > > =A0 > > =A0 > > Thanks and Regards > > Ram