<div dir="ltr"><div>Hello,</div><div><br></div><div>In attachment, you can find more logs of pgpool.</div><div><br></div><div>I have had a look at this config example already. What is .pgpoolkey file format? How do we create it, with a encryption key generation?</div><div><br></div><div>Best regards,</div><div><br></div><div>Lionel Engel<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 5 juin 2019 à 04:00, Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@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 Tue, 4 Jun 2019 08:43:04 +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 I am starting pgpool on 2 servers in same PgPool<br>
> cluster (watchdog).<br>
> <br>
> My PgPool standby server running on CentOS 6 with PgPool 4.0.5 is returning<br>
> an error that is saying "Could not get the password for user:postgres.<br>
> Unable to decrypt password from pool_passwd."<br>
> <br>
> I have a .pgpoolkey file and I have used *pg_enc* tool to generate the<br>
> SCRAM-SHA-256 encrypted password in *pool_passwd*.<br>
<br>
Could you show more logs of pgpool?<br>
<br>
Also you can find more details from the config example below:<br>
<a href="http://www.pgpool.net/docs/latest/en/html/example-cluster.html" rel="noreferrer" target="_blank">http://www.pgpool.net/docs/latest/en/html/example-cluster.html</a><br>
<br>
<br>
> What is wrong?<br>
> <br>
> Thank you in advance and best regards,<br>
> <br>
> Lionel Engel<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div>