<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi everyone. <div class="">I am using pgpool 3.3.4 (replication mode) and postgresql 9.3 on all clusters with ubuntu 14.04 , i installed pg_recovery on every machine.</div><div class=""><br class=""></div><div class="">This is my network configuration :</div><div class=""><br class=""></div><div class="">172.16.16.100 pgpool server</div><div class="">172.16.16.104 node0 —> offline node to recover</div><div class=""><div class="">172.16.16.105 node1</div></div><div class=""><div class="">172.16.16.106 node2 </div></div><div class=""><br class=""></div><div class="">On pgpool server i run :</div><div class=""><br class=""></div><div class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">pcp_recovery_node -d 200 localhost 9898 postgres postgres 0</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: send: tos="R", len=46</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: recv: tos="r", len=21, data=AuthenticationOK</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: send: tos="D", len=6</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: recv: tos="e", len=20, data=recovery failed</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: command failed. reason=recovery failed</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">BackendError</span><br style="font-family: monospace;" class=""><span style="font-family: monospace; font-size: medium; background-color: rgb(255, 255, 255);" class="">DEBUG: send: tos="X", len=4</span></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">If manually start copy_base_backup (1st stage recovery command) on node1 or node2 with right parameters to recovery node0 everything works fine.</div><div class=""><br class=""></div><div class="">Here are my questions :</div><div class=""> - Considered that the master node is offline , witch node should be used to restore node0 ?</div><div class=""> - What should be the problem ?</div><div class=""> - What should i do to debug and get more informations about this backed error ?</div><div class=""><br class=""></div><div class="">Thanks everyone,</div><div class="">Ambrosini Luca</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>