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

Lionel Engel lionel.engel6 at gmail.com
Thu Jun 6 18:30:36 JST 2019


Hello,

Yes, pool_passwd contains postgres user with AES256 password.

Please find in attachment pgpool.log postgresql.log

Lionel Engel

Le jeu. 6 juin 2019 à 05:09, Takuma Hoshiai <hoshiai at sraoss.co.jp> a écrit :

> 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>
> > >
> > >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190606/3082ab74/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgres.log
Type: application/octet-stream
Size: 3397 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190606/3082ab74/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 1522 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190606/3082ab74/attachment-0001.obj>


More information about the pgpool-general mailing list