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 5A38852A8E for ; Tue, 8 Mar 2005 16:49:38 +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 27686-07 for ; Tue, 8 Mar 2005 16:49:21 +0000 (GMT) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id 247CC52A55 for ; Tue, 8 Mar 2005 16:49:19 +0000 (GMT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id E9D261038E; Tue, 8 Mar 2005 08:49:18 -0800 (PST) From: Steve Crawford Organization: Pinpoint Research To: "ganapatiram" , Subject: Re: Too many clients----A big problem for my team Date: Tue, 8 Mar 2005 08:49:18 -0800 User-Agent: KMail/1.5.1 References: <003101c52316$bd8e4f00$8c0aa8c0@rram> In-Reply-To: <003101c52316$bd8e4f00$8c0aa8c0@rram> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200503080849.18471.scrawford@pinpointresearch.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.115 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/115 X-Sequence-Number: 16613 > 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 ... > I have max_connections=200 and i have 5 users for my DB. I > dont understand what to do in order to resolve this... What is your _server_ telling you? Check the logs. Check ps for instances of postgres. Check netstat for connections to PG and track back to the source point of each of the connections. Keep a connection open to your server so you can run "select * from pg_stat_activity;" to see what queries are running. You will probably find: 1) Your app is lying to you or is connecting to a different server than you assumed if you have multiple servers. 2) You don't really have 200 connections (did you restart after changing your config?) 3) Your app is making more connections than you think. (Doing any pooling??) 4) Your apps aren't closing connections that you thought were being closed. Cheers, Steve