[pgpool-general: 6585] Re: Old master recovery after failover error "unable to connect to master node"

[Takuma Hoshiai]

Hi, 

On Wed, 5 Jun 2019 13:20:15 +0200
Lionel Engel <lionel.engel6 at gmail.com> wrote:

> Hello,
> 
> So I have tried to connect to postgresql through *psql -p 9999* with user
> postgres and without password and connection is successful.

Thank you for your confirmation.

Does pool_passwd file contain postgres user?
And, could you share pgpool.log and primary's postgresql.log when recovery failed?


Best regards,
-- 
Takuma Hoshiai <hoshiai at sraoss.co.jp>

> Best regards,
> 
> Lionel Engel
> 
> Le jeu. 23 mai 2019 à 09:37, Takuma Hoshiai <hoshiai at sraoss.co.jp> a écrit :
> 
> > 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>
> >
> >