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 93CA15643D for ; Wed, 9 Mar 2005 11:36:05 +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 79797-07 for ; Wed, 9 Mar 2005 11:36:04 +0000 (GMT) Received: from tinet.org (mail.tinet.org [195.77.216.130]) by svr1.postgresql.org (Postfix) with ESMTP id C5ADA563F6 for ; Wed, 9 Mar 2005 11:36:02 +0000 (GMT) Received: (qmail 4123 invoked from network); 9 Mar 2005 11:36:03 -0000 Received: from serena.tinet.org (HELO tinet.org) ([194.224.210.4]) (envelope-sender ) by mail.tinet.org (SMTP OASI) with SMTP for ; 9 Mar 2005 11:36:03 -0000 Message-ID: <422EDF21.4080903@tinet.org> Date: Wed, 09 Mar 2005 12:33:53 +0100 From: Daniel Rubio User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Too many clients----A big problem for my team References: <003101c52316$bd8e4f00$8c0aa8c0@rram> In-Reply-To: <003101c52316$bd8e4f00$8c0aa8c0@rram> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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: 200503/123 X-Sequence-Number: 16621 I had the same problem a few weeks ago. Was happening that our developers using Tomcat, were using connection pools, and stoping and restarting their aplications which causes to leave these connection opened and opening some new. Look in the servlet engine (or what they use) for the number of connections they made (in Tomcat it's a parameter), say them not to leave the connections opened, and not to stop and restart the java application when they make changes, they must restart the "engine" (it closes all the opened connections). It worked for me ... ganapatiram wrote: > 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. * > > ** > > * *I have max_connections=200 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. > > > > > > Waiting for your valuable suggestion.......... > > > > > > > > > > Thanks and Regards > > Ram > -- ******************************************************** Daniel Rubio Rodríguez OASI (Organisme Autňnom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: drubio a oasi.org ********************************************************