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

Bo Peng pengbo at sraoss.co.jp
Tue Apr 7 09:34:52 JST 2020


On Mon, 6 Apr 2020 14:52:31 +0530
Lakshmi Raghavendra <lakshmiym108 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 :
> wdc-interop129-7:/db/data # /usr/local/bin/pcp_recovery_node -h delegateIp
> -p 9898 -U pgpool -n 1
> Password:
> ERROR:  node recovery failed, unable to connect to master node: 0

This error message means that Pgpool-II can't connect to master node 0.
Please check if the master node is started and connected by Pgpool-II.

    $ psql -h delegateIp -p 9999 -U pgpool -c "show pool_nodes"
> Please let us know at the earliest, as we are at the verge of a production
> fix.
> Thanks And Regards,
>    Lakshmi Y M

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

More information about the pgpool-general mailing list