[pgpool-general: 3869] pcp_node_recovery error - debug

[Luca Ambrosini]

Hi everyone. 
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.

This is my network configuration :

172.16.16.100 pgpool server
172.16.16.104 node0 —> offline node to recover
172.16.16.105 node1
172.16.16.106 node2 

On pgpool server i run :

pcp_recovery_node -d 200 localhost 9898 postgres postgres 0
DEBUG: send: tos="R", len=46
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
BackendError
DEBUG: send: tos="X", len=4


If manually start copy_base_backup (1st stage recovery command) on node1 or node2 with right parameters to recovery node0 everything works fine.

Here are my questions :
 - Considered that the master node is offline , witch node should be used to restore node0 ?
 - What should be the problem ?
 - What should i do to debug and get more informations about this backed error ?

Thanks everyone,
Ambrosini Luca



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150713/3d985c4e/attachment.html>