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--