Re: hanging Postgres connections....

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: hanging Postgres connections....
Date: 2007-09-24 14:08:43
Message-ID: 640119.54052.qm@web56410.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Postgres: 8.2.4

IRIX: IRIX64 machinename 6.5

Thanks.
Jessica

"Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)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(dot)harris(at)enterprisedb(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-09-24 21:59:45 Re: wholly / partially table read into shared buffer
Previous Message Jonah H. Harris 2007-09-24 13:54:37 Re: hanging Postgres connections....