[pgpool-general: 6569] Re: Old master recovery after failover error "unable to connect to master node"
Takuma Hoshiai
hoshiai at sraoss.co.jp
Thu May 23 16:37:51 JST 2019
Hi,
What do you use pgpool version?
On Mon, 20 May 2019 08:55:15 +0200
Lionel Engel <lionel.engel6 at gmail.com> wrote:
> Hello,
>
> I have an issue when trying to recover my old master after a failover
> occured.
>
> Automatic recovery failed, so I tried to run *pcp_recovery_node *but an
> error return saying "node recovery failed, unable to connect to master
> node: 1". Can you please advise me?
This error means that recovery_user didn't connect master node,
so recovery process was not started( recovery_1st_stage.sh not executed too).
pgpool.conf contain:
recovery_user = 'postgres'
recovery_password = ''
Can you connect postgresql through pgpool, using 'postgres' user and no password?
If you can't connect, you set 'recovery_password'.
> In attachment, you can find my recovery_1st_stage script and my pgpool.conf.
>
> Thanks in advance. Best regards,
>
> Lionel Engel
Best regards,
--
Takuma Hoshiai <hoshiai at sraoss.co.jp>
More information about the pgpool-general
mailing list