you can test each command reside in basebackup.sh via terminal using user postgres, so you can tell which command failed<br><br><div class="gmail_quote">On Tue, Aug 28, 2012 at 11:49 AM, Kent Tong <span dir="ltr"><<a href="mailto:kent.tong.mo@gmail.com" target="_blank">kent.tong.mo@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child educator</div><br>
</font></span></div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>