<div dir="ltr"><div>Hi all,<br></div>I have the following question regarding the recovery of a filed Primary Database Server.<br><div><div><br>Question 1: in the documentation, under Streaming Replication Online Recovery section.<br>
<br><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#stream" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#stream</a><br><br>in steps 6:<br><ol><li value="6">After completing online recovery, pgpool-II will start PostgreSQL on
the standby node.
Install the script for this purpose on each DB nodes.
<a href="http://www.pgpool.net/docs/latest/pgpool_remote_start" target="_blank">Sample script</a> 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.
</li></ol><p>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.</p>
<p><br></p><p>Question 2: in my configuration, i have 2 pgpool server with two backends. Will it work for oneline recovery?</p><p>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.</p>
<p><br></p><p>Thank so much for helping!</p><p><br></p><p>Ning<br></p></div></div></div>