[pgpool-general: 8361] Re: Active connection
Bo Peng
pengbo at sraoss.co.jp
Tue Aug 23 13:59:17 JST 2022
Hello,
> 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>
SRA OSS LLC
https://www.sraoss.co.jp/
More information about the pgpool-general
mailing list