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

[Lionel Engel]

For PostgreSQL, I am using SCRAM-SHA-256 authentication method.

Lionel Engel

Le jeu. 6 juin 2019 à 11:30, Lionel Engel <lionel.engel6 at gmail.com> a
écrit :

> 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/3f099cfe/attachment-0001.html>