hanging Postgres connections....
hanging Postgres connections....
От:
Jessica Richard <rjessil@yahoo.com>
Дата:
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.
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.
Re: hanging Postgres connections....
От:
"Jonah H. Harris" <jonah.harris@gmail.com>
Дата:
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/
Re: hanging Postgres connections....
От:
Jessica Richard <rjessil@yahoo.com>
Дата:
Postgres: 8.2.4
IRIX: IRIX64 machinename 6.5
Thanks.
Jessica
"Jonah H. Harris" <jonah.harris@gmail.com> wrote:
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
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.