From rjessil@yahoo.com Mon Sep 24 13:50:17 2007 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-- From jonah.harris@gmail.com Mon Sep 24 13:54:44 2007 Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C890D9F9FA3 for ; Mon, 24 Sep 2007 10:54:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 11138-02-3 for ; Mon, 24 Sep 2007 10:54:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.224]) by postgresql.org (Postfix) with ESMTP id 958BA9F9F89 for ; Mon, 24 Sep 2007 10:54:39 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so495401wri for ; Mon, 24 Sep 2007 06:54:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=iJUi2j0Z4yeHNx4HXtNAwAuKxKIbJ8F0ErYDCu4PcB0=; b=cqgzG1Uy+PURyVaw4XAAv0TuoPXTBNXZO6pbXVnbzguaxB5CLcGJIIB7QBGaJJ/5VZWc0B/yTBZhMZCZ5vxnVWBMQ/ayR7z8WMAkv9J9RM7T/j3tmH63cjE6Gk4ewrEqaUtX+WEK1ZMVPtfj6Fio7toeRxJOJmsJAIVZNiCdSco= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WLiDQxBaiOw+U2olrrr0r72LmSH6lsveyuKpAnj3tbNK0rXDuJBpec/e84AKp44y1G8A33N4/6auX7XIHuS6J1bzVOv+26pvgr2/2rsilaqZNM8HJoD5mGS3Dm/ej6lWulfDKh8HVrHCJ25pf32U7ro8fSjbBVHuubbWXdrZFOI= Received: by 10.142.115.10 with SMTP id n10mr383649wfc.1190642077734; Mon, 24 Sep 2007 06:54:37 -0700 (PDT) Received: by 10.143.19.7 with HTTP; Mon, 24 Sep 2007 06:54:37 -0700 (PDT) Message-ID: <36e682920709240654t7c3e1c56ra8422b854d8be831@mail.gmail.com> Date: Mon, 24 Sep 2007 09:54:37 -0400 From: "Jonah H. Harris" To: "Jessica Richard" Subject: Re: hanging Postgres connections.... Cc: pgsql-admin@postgresql.org In-Reply-To: <98696.25763.qm@web56409.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <98696.25763.qm@web56409.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/143 X-Sequence-Number: 26904 On 9/24/07, Jessica Richard wrote: > 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... What version of Postgres and IRIX are you running? -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/ From rjessil@yahoo.com Mon Sep 24 14:08:50 2007 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 914AA9F9A22 for ; Mon, 24 Sep 2007 11:08:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85827-09 for ; Mon, 24 Sep 2007 11:08:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56410.mail.re3.yahoo.com (web56410.mail.re3.yahoo.com [216.252.111.89]) by postgresql.org (Postfix) with SMTP id 6AD3E9F9CBC for ; Mon, 24 Sep 2007 11:08:45 -0300 (ADT) Received: (qmail 54897 invoked by uid 60001); 24 Sep 2007 14:08:43 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Fw8we3gGmi0g7b4gdsHxiRsdnsrXX085xs/4bsVKd7zb8EY0P6kpdO4NN2Dy1dKz0TuiE0mw99zwU7b1JXqD8jAif/lKorXBRGTYdYRks1Khb67WRWdyxNyip9CoE53xT/Yb4cCbY/s/v49dVC3UxGYimLFv3ohueFGAt8FZY1Q=; X-YMail-OSG: XVKLh40VM1ntKbsXNobhfNjptX7b47uFXqTe9NTUeMraekSOqtuqekzDi9FABAo3ZhnaY8ogfHJzh6mtvK.1OyS2fR0znO4izMQcgOZ8mYBmJvIkEcGqrC.We61ZDp6ZYNsQbw1sKG9dTI1M.R8YIk7K1w-- Received: from [198.119.134.32] by web56410.mail.re3.yahoo.com via HTTP; Mon, 24 Sep 2007 07:08:43 PDT Date: Mon, 24 Sep 2007 07:08:43 -0700 (PDT) From: Jessica Richard Subject: Re: hanging Postgres connections.... To: "Jonah H. Harris" Cc: pgsql-admin@postgresql.org In-Reply-To: <36e682920709240654t7c3e1c56ra8422b854d8be831@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-458738839-1190642923=:54052" Content-Transfer-Encoding: 8bit Message-ID: <640119.54052.qm@web56410.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/144 X-Sequence-Number: 26905 --0-458738839-1190642923=:54052 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Postgres: 8.2.4 IRIX: IRIX64 machinename 6.5 Thanks. Jessica "Jonah H. Harris" wrote: On 9/24/07, Jessica Richard wrote: > 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... What version of Postgres and IRIX are you running? -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel. --0-458738839-1190642923=:54052 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Postgres:  8.2.4

IRIX:   IRIX64 machinename 6.5

Thanks.
Jessica


"Jonah H. Harris" <jonah.harris@gmail.com> wrote:
On 9/24/07, Jessica Richard wrote:
> 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...

What version of Postgres and IRIX are you running?

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Need a vacation? Get great deals to amazing places on Yahoo! Travel. --0-458738839-1190642923=:54052--