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

[Tatsuo Ishii]

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

No, you cannot recover the primary node by using pcp_recovery_node
(it's prohibited by design). If you believe that your primary node is
broken:

1) Promote one of standby server to create a new primary node. Do
   *not* use pcp_promoto_node here. You need to execute pg_ctl promote.

2) Shutdown the broken primary server.

3) Recover the broken primary server by using pcp_recovery_node.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp