[pgpool-general: 1388] pgPool Online Recovery Streaming Replication

[ning chan]

Hi all,
I have the following question regarding the recovery of a filed Primary
Database Server.

Question 1: in the documentation, under Streaming Replication Online
Recovery section.

http://www.pgpool.net/docs/latest/pgpool-en.html#stream

in steps 6:

   1. After completing online recovery, pgpool-II will start PostgreSQL on
   the standby node. Install the script for this purpose on each DB
nodes. Sample
   script <http://www.pgpool.net/docs/latest/pgpool_remote_start> is
   included in "sample" directory of the source code. This script uses ssh.
   You need to allow recovery_user to login from the primary node to the
   standby node without being asked password.

To my understanding, i think the postgreSQL doesn't not need to be online
for the recovery process right? Since later on it mentions that
pgpool_remote_start will start up the DB on the failed node.


Question 2: in my configuration, i have 2 pgpool server with two backends.
Will it work for oneline recovery?

Question 3: when the failed node comes back online, should i use
pcp_recovery from DB primary or should i use pcp_attach on the failed node
to recover the failed system? Actually in my case, both methods do not
recover my system every time.


Thank so much for helping!


Ning
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130213/ca84d22d/attachment.html>