<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:14pt"><div id="yiv5674127412"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 14pt;"><div style="margin-top: 0.1em; margin-bottom: 0.1em;">Dear Jeff,</div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent;"><br></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent;"><span> Thanks for your reply. As you have mentioned I have done two things first i ran the rsync command without the </span><span style="font-size: 14pt; background-color: transparent;">--exclude pg_xlog</span><span style="font-size: 14pt; background-color: transparent;"> option then clicked on recovery the end result was recovery took 10 seconds longer to process but as usual
on the third try it gave the same <span style="font-weight: bold;">error code i.e e1012 & error message: pcp_recovery_node command error occurred</span></span><span style="background-color: transparent;"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">.</font></span></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent;"><span style="background-color: transparent;"><font face="Verdana, Arial, Helvetica, sans-serif" style="font-size: 13px;"></font><font style="font-size: 18px;"><span class="Apple-tab-span" style="white-space: pre;"> </span>The second time I deleted the pg_xlog folder content manually and then ran the recovery button the end result was this time the<span style="font-weight: bold;"> error code: e1012 popped up in 5 seconds with the same error message: </span></font></span><span style="font-weight: bold;"><span style="font-size: 14pt;">pcp_recovery_node command error
occurred.</span><span style="font-size: 18px; background-color: transparent;"> </span></span></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent; font-size: 18px;"><span style="background-color: transparent;"> Now in order to recover the failed node i have to stop both the databases manually and pgpool two to three times to finally recover the failed node as standby node.</span></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent; font-size: 18px;"><span style="background-color: transparent;"> Please guide me how to resolve the issue the details of the system and software versions used are </span></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent; font-size: 18px;"><span style="background-color: transparent;">1) pgpool version 3.3.0 on 1st system(CentOS
6)</span></div><div style="margin-top: 0.1em; margin-bottom: 0.1em; background-color: transparent; font-size: 18px;"><span style="background-color: transparent;">2) postgres 9.1.1 on second system primary(CentOS 6)</span></div><div id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_10"><span style="background-color: transparent; font-size: 18px;">3) postgres 9.1.1 on third system standby(CentOS 6)</span></div><div id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_10"><span style="font-size: 14pt;"> </span><br></div><div id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_16">Thanks and
Regards,</div><div id="yiv5674127412yui_3_13_0_ym1_1_1390811738817_6746"><span style="font-size: 14pt;">Syed Irfan.</span><br></div><div id="yiv5674127412yui_3_13_0_ym1_1_1390811738817_6747"><span id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_39" style="font-size:14pt;">Sr. Developer</span><br clear="none"></div><div id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_27"><br clear="none"></div><div class="yiv5674127412yqt6250304960" id="yiv5674127412yqt83492"><div class="yiv5674127412yahoo_quoted" id="yiv5674127412yui_3_13_0_ym1_6_1390811738817_30" style="display: block;"> <br clear="none"> <br clear="none"> <div class="yiv5674127412yui_3_13_0_ym1_1_1390811738817_6677" style="font-family: 'times new roman', 'new york', times, serif; font-size: 14pt;"> <div class="yiv5674127412yui_3_13_0_ym1_1_1390811738817_6678" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> On Saturday, 25
January 2014 1:47 AM, Jeff Frost <jeff@pgexperts.com> wrote:<br clear="none"> </font> </div> <div class="yiv5674127412y_msg_container"><div id="yiv5674127412">
<div>
<div class="yiv5674127412moz-cite-prefix">On 01/23/14 20:30, Syed Irfan wrote:<br clear="none">
</div>
<blockquote type="cite">
<div style="background-color:transparent;">rsync -C -a -c
--delete --exclude postgresql.conf --exclude postmaster.pid \</div>
<div style="background-color:transparent;">--exclude
postmaster.opts --exclude pg_log \</div>
<div style="background-color:transparent;">--exclude
recovery.conf --exclude recovery.done \</div>
<div style="background-color:transparent;">--exclude pg_xlog \</div>
<div style="background-color:transparent;">$master_db_cluster/
$recovery_node_host_name:$recovery_db_cluster</div>
</blockquote>
<br clear="none">
So, is the $recovery_db_cluster on the replica node empty when the
base backup starts? It seems like it might have had some WAL files
in it from a previous test.<br clear="none">
<br clear="none">
I think because you're excluding pg_xlog, rsync doesn't process the
--deletes on it, so you need to make sure and clean it out on the
replica if there were any existing WAL files before starting
postgres.<br clear="none">
<br clear="none">
<br clear="none">
<br clear="none">
<pre class="yiv5674127412moz-signature">--
Jeff Frost <a rel="nofollow" shape="rect" class="yiv5674127412moz-txt-link-rfc2396E" ymailto="mailto:jeff@pgexperts.com" target="_blank" href="mailto:jeff@pgexperts.com"><jeff@pgexperts.com></a>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
<a rel="nofollow" shape="rect" class="yiv5674127412moz-txt-link-freetext" target="_blank" href="http://www.pgexperts.com/">http://www.pgexperts.com/</a>
</pre>
</div>
</div><br clear="none"><br clear="none"></div> </div> </div> </div></div> </div></div></div></div></body></html>