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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
