<div dir="ltr"><div>Hello,</div><div><br></div><div>Yes, pool_passwd contains postgres user with AES256 password.</div><div><br></div><div>Please find in attachment pgpool.log postgresql.log</div><div><br></div><div>Lionel Engel<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le jeu. 6 juin 2019 à 05:09, Takuma Hoshiai <<a href="mailto:hoshiai@sraoss.co.jp">hoshiai@sraoss.co.jp</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi, <br>
<br>
On Wed, 5 Jun 2019 13:20:15 +0200<br>
Lionel Engel <<a href="mailto:lionel.engel6@gmail.com" target="_blank">lionel.engel6@gmail.com</a>> wrote:<br>
<br>
> Hello,<br>
> <br>
> So I have tried to connect to postgresql through *psql -p 9999* with user<br>
> postgres and without password and connection is successful.<br>
<br>
Thank you for your confirmation.<br>
<br>
Does pool_passwd file contain postgres user?<br>
And, could you share pgpool.log and primary's postgresql.log when recovery failed?<br>
<br>
<br>
Best regards,<br>
-- <br>
Takuma Hoshiai <<a href="mailto:hoshiai@sraoss.co.jp" target="_blank">hoshiai@sraoss.co.jp</a>><br>
<br>
> Best regards,<br>
> <br>
> Lionel Engel<br>
> <br>
> Le jeu. 23 mai 2019 à 09:37, Takuma Hoshiai <<a href="mailto:hoshiai@sraoss.co.jp" target="_blank">hoshiai@sraoss.co.jp</a>> a écrit :<br>
> <br>
> > Hi,<br>
> ><br>
> > What do you use pgpool version?<br>
> ><br>
> > On Mon, 20 May 2019 08:55:15 +0200<br>
> > Lionel Engel <<a href="mailto:lionel.engel6@gmail.com" target="_blank">lionel.engel6@gmail.com</a>> wrote:<br>
> ><br>
> > > Hello,<br>
> > ><br>
> > > I have an issue when trying to recover my old master after a failover<br>
> > > occured.<br>
> > ><br>
> > > Automatic recovery failed, so I tried to run *pcp_recovery_node *but an<br>
> > > error return saying "node recovery failed, unable to connect to master<br>
> > > node: 1". Can you please advise me?<br>
> ><br>
> > This error means that recovery_user didn't connect master node,<br>
> > so recovery process was not started( recovery_1st_stage.sh not executed<br>
> > too).<br>
> ><br>
> > pgpool.conf contain:<br>
> > recovery_user = 'postgres'<br>
> > recovery_password = ''<br>
> ><br>
> > Can you connect postgresql through pgpool, using 'postgres' user and no<br>
> > password?<br>
> > If you can't connect, you set 'recovery_password'.<br>
> ><br>
> > > In attachment, you can find my recovery_1st_stage script and my<br>
> > pgpool.conf.<br>
> > ><br>
> > > Thanks in advance. Best regards,<br>
> > ><br>
> > > Lionel Engel<br>
> ><br>
> ><br>
> > Best regards,<br>
> ><br>
> > --<br>
> > Takuma Hoshiai <<a href="mailto:hoshiai@sraoss.co.jp" target="_blank">hoshiai@sraoss.co.jp</a>><br>
> ><br>
> ><br>
<br>
</blockquote></div>