[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