[pgpool-general: 7414] Re: PCP_RECOVERY not working - very important

Bo Peng pengbo at sraoss.co.jp
Fri Feb 12 10:28:57 JST 2021


On Tue, 9 Feb 2021 22:18:57 +0530
Anusha Natarajan <anunataraj194 at gmail.com> wrote:

>  Hi Pgpool team,
>          Am using pgpool for a production system and looks like when i do a
>  pcp_recovery to recover my slave nodes, it errors out as below :
> " ERROR:  node recovery failed, unable to connect to master node:
> 0"(attached screenshots)
> PS: I see delegate Ip is assigned only on the postgres primary node and
> pgpool, postgres service is up on all the nodes
> Please let us know at the earliest, as we are at the verge of a production
> fix.

I want to figure out the reason.
If you specify the IP address, can you run pcp_recovery_node successfully?

  /usr/local/bin/pcp_recovery_node -h xxx.xxx.xxx.xxx -p 9898 -U pgpool -n 2

If it fails, could you share your pgpool.conf and pgpool log files?

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list