[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
Hi,
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