[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
Japanese:http://www.sraoss.co.jp
> 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