what recovery method do you use ? PITR or rsync ? I use PITR method from Gerd's tutorial (<a href="http://www.pgpool.net/pgpool-web/contrib_docs/pgpool-II_for_beginners.pdf">http://www.pgpool.net/pgpool-web/contrib_docs/pgpool-II_for_beginners.pdf</a>), everything goes well for the recovery.<br>
<br><div class="gmail_quote">On Tue, Aug 28, 2012 at 12:02 PM, 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">
The basebackup.sh is very simple: just print something to a log:<div><br></div><div><div>#! /bin/sh</div></div><div>datadir=$1</div><div><div>desthost=$2</div><div>destdir=$3</div><div><br></div><div>echo "recovering: " $desthost >> /tmp/f1.log</div>
<div>echo $* >> /tmp/f1.log</div><div>exit 0</div><div><div class="h5"><div><br></div><div class="gmail_quote">On Tue, Aug 28, 2012 at 12:57 PM, Soni Maula Harriz <span dir="ltr"><<a href="mailto:soni.harriz@sangkuriang.co.id" target="_blank">soni.harriz@sangkuriang.co.id</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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"><div><div>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>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>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><font color="#888888"><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child educator</div><br>
</font></span></div>
<br></div></div>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">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><span><font color="#888888"><br><br clear="all"><br>-- <br>Best Regards,<br><br>Soni Maula Harriz<br>Database Administrator<br>PT. Data Aksara Sangkuriang<br><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child educator</div><br>
</div></div></div>
</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>