[Pgpool-general] [pgpool] Online Recovery

[Tatsuo Ishii]

> Hi, Tatsuo.
>  
> After 1st stage recovery happens, pgpool stops receiving new
> connections, and then 2nd stage recovery starts. If the clients never
> disconnect, 2nd stage will never execute (right?).

Correct. 

BTW, I'm working on new client_idle_limit_in_recovery directive for
next release. This will prevent a client from sitting idle forever in
2nd stage.

> So, is there a way
> (through a script, for example) of knowing what stage is the online
> recovery process at?

Currently no. The only way to know that is looking into log file.
--
Tatsuo Ishii
SRA OSS, Inc. Japan