pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhanging Postgres connections....
3+ messages / 2 participants
[nested] [flat]
* hanging Postgres connections....
@ 2007-09-24 13:50 Jessica Richard <rjessil@yahoo.com>
2007-09-24 13:54 ` Re: hanging Postgres connections.... Jonah H. Harris <jonah.harris@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jessica Richard @ 2007-09-24 13:50 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: hanging Postgres connections....
2007-09-24 13:50 hanging Postgres connections.... Jessica Richard <rjessil@yahoo.com>
@ 2007-09-24 13:54 ` Jonah H. Harris <jonah.harris@gmail.com>
2007-09-24 14:08 ` Re: hanging Postgres connections.... Jessica Richard <rjessil@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jonah H. Harris @ 2007-09-24 13:54 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: hanging Postgres connections....
2007-09-24 13:50 hanging Postgres connections.... Jessica Richard <rjessil@yahoo.com>
2007-09-24 13:54 ` Re: hanging Postgres connections.... Jonah H. Harris <jonah.harris@gmail.com>
@ 2007-09-24 14:08 ` Jessica Richard <rjessil@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jessica Richard @ 2007-09-24 14:08 UTC (permalink / raw)
To: Jonah H. Harris <jonah.harris@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-09-24 14:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-24 13:50 hanging Postgres connections.... Jessica Richard <rjessil@yahoo.com>
2007-09-24 13:54 ` Jonah H. Harris <jonah.harris@gmail.com>
2007-09-24 14:08 ` Jessica Richard <rjessil@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox