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 317DF563FB for ; Mon, 7 Mar 2005 13:12: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 51751-01 for ; Mon, 7 Mar 2005 13:12:35 +0000 (GMT) Received: from rs7k.tempdomainname.com (rs7k.tempdomainname.com [198.173.255.221]) by svr1.postgresql.org (Postfix) with ESMTP id DC6A3564A5 for ; Mon, 7 Mar 2005 13:12:20 +0000 (GMT) Received: from rram ([220.227.243.250]) (authenticated bits=0) by rs7k.tempdomainname.com (8.13.1/8.12.6) with ESMTP id j27DCLDY044574 for ; Mon, 7 Mar 2005 13:12:23 GMT (envelope-from ganapatiram@symphonydata.com) Message-ID: <003101c52316$bd8e4f00$8c0aa8c0@rram> Reply-To: "ganapatiram" From: "ganapatiram" To: Subject: Too many clients----A big problem for my team Date: Mon, 7 Mar 2005 18:38:15 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002E_01C52344.D2BB0F70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200503/108 X-Sequence-Number: 16606 This is a multi-part message in MIME format. ------=_NextPart_000_002E_01C52344.D2BB0F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Experts, I work with postgresql 8.0 version. I have a team of 14 = developers. When all the team connects the DB i see this error very very = frequently which is a severe problem for me and team all the day. The = error is: Please report this exception: java.sql.SQLException: FATAL: sorry, too = many clients already when i do trial and error changes i see this error differently but the = essense of the error remains same.=20 I have max_connections=3D200 and i have 5 users for my DB. I = dont understand what to do in order to resolve this. Please suggest me = something by which i can overcome this problem. I referred few threads = but none of them are of my case.=20 Waiting for your valuable suggestion.......... Thanks and Regards Ram ------=_NextPart_000_002E_01C52344.D2BB0F70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Experts,
 
           I = work with=20 postgresql 8.0 version. I have a team of 14 developers. When all the = team=20 connects the DB i see this error very very frequently which is a severe = problem=20 for me and team all the day. The error is:
 

Please report this exception: java.sql.SQLException: = FATAL:  sorry, too many clients=20 already

 

when i=20 do trial and error changes i see this error differently but the essense = of the=20 error remains same.

 

   =20     I have max_connections=3D200 and i have 5 = users for my=20 DB. I 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 = but none=20 of them are of my case.

 

 

Waiting=20 for your valuable suggestion..........

 

 

 

 

Thanks=20 and Regards

Ram

------=_NextPart_000_002E_01C52344.D2BB0F70--