[pgpool-general: 3718] Re: Pgpooladmin web page hanging

[Tatsuo Ishii]

> Hi,
> 
> When a standby box is switched off, the pgpooladmin web page seems to hang for a while. Clicking on any button doesn't help.
> 
> What is happening? Is there a timeout that I can set so that pgpooladmin is more responsive?

You don't show any detail about your pgpool-II version, pgpoolAdmin
nor OS, so below is just my guess.

I assume "a standby box is switched off" means one of your standby
PostgreSQL is shutting down. I guess what happens is, pgpool-II
executes failover process which may take for a while. Unfortunately
pgpool-II does not accept any other pcp command which was issued by
pgpoolAdmin until failover finishes. So pgpoolAdmin has to wait until
on line recovery finishes.

The next version of pgpool-II, which is pgpool-II 3.5 (we expect it
will be out on this fall), overcomes the problem.

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