Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AEE8F9F9F03 for ; Mon, 24 Sep 2007 10:50:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79598-05 for ; Mon, 24 Sep 2007 10:50:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56409.mail.re3.yahoo.com (web56409.mail.re3.yahoo.com [216.252.111.88]) by postgresql.org (Postfix) with SMTP id A89229F9E64 for ; Mon, 24 Sep 2007 10:50:14 -0300 (ADT) Received: (qmail 32278 invoked by uid 60001); 24 Sep 2007 13:50:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=hB+J/dK/E82gshUnEBhLZE+hys9ek90quIVYb05dsXK4R0+UJkaoNPVTbhCwSBajiURX+R4dh4MjC8rv0SRfwlMOebmXHWdBFailvEto8vb8ABhm9M1bQnvTZ0KEzJUcqrshgU8n8gmrrqejMic01govRR8ug/P125njHl9HJ/M=; X-YMail-OSG: KuqNqV8VM1khDHhT5HFd1QDyiiyvvHOw4RYD5ijRhtmk4EUWe4yMB.Lhwf2PKjaPo6QordNDYuPD6B4zVVwUNq4JsAab5UfZ64wrblhrj7TroIY4AddE2bGIm8yXyIsntilJLfF2lZInurBr9D89dRQ- Received: from [198.119.134.32] by web56409.mail.re3.yahoo.com via HTTP; Mon, 24 Sep 2007 06:50:09 PDT Date: Mon, 24 Sep 2007 06:50:09 -0700 (PDT) From: Jessica Richard Subject: hanging Postgres connections.... To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-199773890-1190641809=:25763" Content-Transfer-Encoding: 8bit Message-ID: <98696.25763.qm@web56409.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/142 X-Sequence-Number: 26903 --0-199773890-1190641809=:25763 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I am seeing a lot of hanging Postgres connections on one Postgre server (IRIX platform). The main user uses a perl script talking to the database (insert, update, etc). Those hanging connections are in "IDLE" state and they look very old... Why are those jobs not releasing their connections when they are done??? Thanks, Jessica --------------------------------- Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. --0-199773890-1190641809=:25763 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I am seeing a lot of hanging Postgres connections on one Postgre server (IRIX platform). The main user uses a perl script talking to the database (insert, update, etc). Those hanging connections are in "IDLE" state and they look very old...

Why are those jobs not releasing their connections when they are done???

Thanks,
Jessica


Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. --0-199773890-1190641809=:25763--