[pgpool-general: 8361] Re: Active connection

Bo Peng pengbo at sraoss.co.jp
Tue Aug 23 13:59:17 JST 2022


> Hi,
> I am using pgoool version 4.2.5 and  noticed somerhing disturbing.
> pg_stat_statements showed one query in active state for long time, then I checked  network connecrions between pgpool and postgresql using netstat and connection between pgpool and frontend.
> Connection between pgpool and postgresql is established but between pgpool and frontend is missed. 
> command on pgpool:
> ps aux showed IP and port of „connected„ frontend but connection in netstat is missed.
> Why and what could have happened ?
> How I can diagnose that ?

Your question is why the established connections was remained even there aren't any clients?
This behavior is due to connection pooling feature.

You can disable this feature using:

    connection_cache = off

Bo Peng <pengbo at sraoss.co.jp>

More information about the pgpool-general mailing list