[Pgpool-general] [pgpool] Online Recovery

[Jaume Sabater]

----- "marco perugini" <m.perugini at 4it.it> wrote:

> 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?

Your script would execute something like:

pcp_recovery_node <timeout> <hostname> <port> <admin> <password> <node_id>

Or the attach command, but pcp_recovery_node already does that. Nevertheless, I would not recommend triggering such action in any automatic form.

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"