Joshua D. Drake wrote:
> Alvaro Herrera wrote:
> >Joshua D. Drake wrote:
> >>Alvaro Herrera wrote:
> >>>What I've been wondering all along is whether they are using a
> >>>connection pool.
> >>Yes they are using a connection pool. A java based one.
> >
> >It's quite possible that it's the connection pool that gets confused,
> >and not PostgreSQL itself. It would be interesting if they change the
> >connection setting when the "hang" next occurs, to point directly to
> >PostgreSQL bypassing the connection pool.
>
> Well except when they are connecting with Pgadmin (which wouldn't go
> through the connection pool) they get the error as well.
Are you assuming, or did they/you verify that this is indeed the case?
I see no reason to assume that pgAdmin can't connect via a pool.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support