m: pgsql-admin-ow...@postgresql.org
> [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of David Johnston
> Sent: 03 October 2013 19:44
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] postgres connections in IDLE state..
>
> Rajagopalan, Jayashree wrote
> > I
Johnston
Sent: 03 October 2013 19:44
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgres connections in IDLE state..
Rajagopalan, Jayashree wrote
> I'm seeing intermittently - the DB connections getting stale - and not
> getting returned to the Hibernate session pool.
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
