[pgpool-general: 5404] Re: pgpool connections in DISCARD status

Tatsuo Ishii ishii at sraoss.co.jp
Fri Mar 31 17:01:57 JST 2017

Pgpool-II 3.4.3 is pretty old (released on Apri 2015). I recommend you
to obtain the latest one (3.4.10). I also I think you could ask
support from EDB.

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

> Hi,
> We are using EDB 9.5 and pgpool 3.4.3.
> We see increasing number of pgpool connections in the DISCARD/ABORT status in spite of the configuring client_idle_limit.
> ps -aef | grep pgpool | grep DISCARD | wc -l
> 290
> We are killing these processes manually now, to avoid a situation where there are no free connections available.
> Please find attached our pgpool configuration and recommend any changes that would release these connections.
> TIA,
> Dhanya

More information about the pgpool-general mailing list