Обсуждение: hanging Postgres connections....

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.

On 9/24/07, Jessica Richard <rjessil@yahoo.com> 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/

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.