Thanks.
But what is the process id that is attached to the connection? Can I track down
or debug/ get more information related to that process id?
Regards
Jayashree
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of David Jo
Rajagopalan, Jayashree wrote
> I'm seeing intermittently - the DB connections getting stale - and not
> getting returned to the Hibernate session pool. Some of the connections
> are as old as 9 days.
The whole point of a connection pool is to keep open connections to the
database. These connectio
Hi all:
Our application uses Jboss-hibernate with Postgres as the backend.
I'm seeing intermittently - the DB connections getting stale - and not getting
returned to the Hibernate session pool. Some of the connections are as old as 9
days.
The pg_stat shows the connection as IDLE in the DB.
da
