[pgpool-general: 4330] Re: Connection Pool

Tatsuo Ishii ishii at postgresql.org
Fri Jan 15 09:15:48 JST 2016

Connection pooling behavior depends on pgpool.conf.  Can we share it?

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

> Hi,
> I'm trying to understand how the connection pool works. Whether I'm getting a connection leak.
> Pgpool v3.4
> Postgres v9.3.10
> Rhel v7.1
> I have 2 applications, the first application A monitors postgres via pgpool. It connects and disconnects continuously every few minutes. The second is an application B that starts up in the morning and stays connected for the whole day, and shutdowns down at night. Both applications use different user accounts to log into Postgres.
> What I've noticed is that in pgpool admin it shows that there are processes that share the same connection even though the username/database/client ip connection combo is different. Though one shows front end connected (app B) and the other is disconnected (app A). Is this ok?
> On the pgpool box, it only shows the connected application B in the list of processes.
> On the Postgres box, it shows both the disconnected app A and the connected app B. I think it is due to what is shown in pgpoolAdmin. The disconnect app A holds an open database connection, even though the app A is no longer running. This connection doesn't disconnect until app B does.
> How can I stop this from happening?
> Kind regards,
> Derek.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

More information about the pgpool-general mailing list