[Pgpool-general] Lockup while using pgbouncer + pgpool

[Tatsuo Ishii]

> BTW, how can I get a count of how many pgpool connections are *active*?
>  pcp_proc_count gives me all of the processes, whether they're connected
> to a backend DB or not.

Use ps command.

22266 ?        S      0:00 pgpool: wait for connection request 

This one is idle.

22267 ?        S      0:00 pgpool: t-ishii test [local] idle 

This one connected from user t-ishii, database test.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp