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

Lionel Engel lionel.engel6 at gmail.com
Wed Jun 5 20:20:15 JST 2019


Hello,

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

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>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190605/32a11ea2/attachment.html>


More information about the pgpool-general mailing list