[pgpool-general: 8361] Re: Active connection

[Bo Peng]

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/