[pgpool-general: 4883] Re: Need some explanation about recovery

[Tatsuo Ishii]

> I have a new question: the recovery script will get executed on the
> 1st stage of the master node or will be the 1st stage of a recovery
> node be executed as well ?

The recovery script will be executed on the primary node.

Pgpool-II sends a query "SELECT pgpool_recovery(...)" to the primary
node and pgpool_recovery function executes the recovery script.

> In the case of my above script, it is build to be executed on 1st
> stage of a node to recover as it delete the old local data path... no
> place for a mistake ;)

Be careful:-)

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