[Pgpool-general] [pgpool] Online Recovery

marco perugini m.perugini at 4it.it
Wed Dec 3 00:38:50 UTC 2008


hi all!
i'm a newbie, so is there a way (through a script, for example) of 
performing recovery online automatically? can a script at boot time on a 
db node invoke the pcp_recovery + pcp_attach commands?
thanks!
marco

Tatsuo Ishii ha scritto:
>> 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
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>
>   



More information about the Pgpool-general mailing list