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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
