Hi,<div><br></div><div>I am using 3.1.3 and working on the online recovery. After issuing the "pcp_recovery_node -d 10 localhost 9898 postgres postgres 0" command to try to recover backend 0, it fails:</div><div>
<br clear="all"><div><div>EBUG: send: tos="R", len=46</div><div>DEBUG: recv: tos="r", len=21, data=AuthenticationOK</div><div>DEBUG: send: tos="D", len=6</div><div>DEBUG: recv: tos="e", len=20, data=recovery failed</div>
<div>DEBUG: command failed. reason=recovery failed</div><div>BackendError</div><div>DEBUG: send: tos="X", len=4</div></div><div><br></div><div>The following messages are found in the log. It means that pgpool connected the to backend 0 successfully but the SELECT failed:</div>
<div><br></div><div><div>Aug 28 12:32:44 pgpool02 pgpool[3791]: starting recovering node 0                            </div><div>Aug 28 12:32:44 pgpool02 pgpool[3791]: starting recovery command: "SELECT pgpool_recovery('basebackup.sh', 'masterdb', '/var/lib/pgsql/9.1/data')"                                        </div>
<div>Aug 28 12:32:44 pgpool02 pgpool[3791]: exec_recovery: basebackup.sh command failed at 1st stage                                  </div></div><div><br></div><div>However, I can use psql to execute that SELECT query on the pgpool machine successfully:</div>
<div><br></div><div><div>[root@pgpool02 pgpool-II-91]# psql -h masterdb -c "SELECT pgpool_recovery('basebackup.sh', 'masterdb', '/var/lib/pgsql/9.1/data')" template1 postgres                                     </div>
<div>Password for user postgres:                                                                  </div><div> pgpool_recovery                                                                             </div><div>-----------------                                                                            </div>
<div> t                                                                                           </div><div>(1 row)       </div></div><div><br></div><div>The recovery_user and recovery_password have been set to "postgres" and its password.</div>
<div><br></div><div>So, any idea why it failed?</div><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child educator</div><br>
</div>