Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4B797476332 for ; Wed, 4 Dec 2002 17:08:34 -0500 (EST) Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110]) by postgresql.org (Postfix) with ESMTP id 427154767F7 for ; Wed, 4 Dec 2002 17:04:57 -0500 (EST) Received: from h-66-167-130-146.phndaz91.covad.net ([66.167.130.146] helo=dominion.dyndns.org) by smtp6.mindspring.com with esmtp (Exim 3.33 #1) id 18Jhda-0002ZD-00 for pgsql-sql@postgresql.org; Wed, 04 Dec 2002 17:04:59 -0500 Received: from there (unknown [10.0.1.2]) by dominion.dyndns.org (Postfix) with SMTP id 94E2778E6 for ; Wed, 4 Dec 2002 15:04:57 -0700 (MST) Content-Type: text/plain; charset="iso-8859-15" From: Mike Diehl To: pgsql-sql@postgresql.org Subject: Ran out of connections Date: Wed, 4 Dec 2002 15:08:35 -0700 X-Mailer: KMail [version 1.3.1] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20021204220457.94E2778E6@dominion.dyndns.org> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/56 X-Sequence-Number: 10644 Hi all. Twice this week, I've come to work to find my Postgres server out of connections... effectively freezing my web server. Today, before I rebooted the entire system, I did a ps -auxw and kept the file to study. I didn't find too many clients running. But I did find a whole LOT of postgres processes running, idle. BTW, one of the postgres processes was doing a vacuum analyze. I'm running 7.2. Can anyone tell me how to fix this? The out put of the ps command can be seen at http://dominion.dyndns.org/~mdiehl/ps.txt Thanx in advance, -- Mike Diehl Network Tools Devl. SAIC at Sandia Labs (505) 284-3137