[pgpool-general: 5614] primary server cannot be recovered by online recovery

Avi Weinberg AviW at gilat.com
Tue Jul 11 00:18:11 JST 2017


Hi Experts,

I tried running pcp_recovery_node command on the node that its database was inaccessible.  I got the following "primary server cannot be recovered by online recovery".  To fix the node I ran pg_basebackup and it went up.  How can a failed node be primary.  Can pcp_recovery_node be used to get out of such situations?

2017-07-09 13:25:24: + pcp_recovery_node -h 172.18.255.40 -p 9898 -U admin -w 1
2017-07-09 13:25:24: ERROR:  process recovery request failed
2017-07-09 13:25:24: DETAIL:  primary server cannot be recovered by online recovery.

Thanks,
Avi
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170710/0a6d9143/attachment.html>


More information about the pgpool-general mailing list