[pgpool-general: 6581] Re: Error "unable to decrypt password from pool_passwd

[Lionel Engel]

Hello,

In attachment, you can find more logs of pgpool.

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?

Best regards,

Lionel Engel

Le mer. 5 juin 2019 à 04:00, Bo Peng <pengbo at sraoss.co.jp> a écrit :

> Hi,
>
> On Tue, 4 Jun 2019 08:43:04 +0200
> Lionel Engel <lionel.engel6 at gmail.com> wrote:
>
> > Hello,
> >
> > I have an issue when I am starting pgpool on 2 servers in same PgPool
> > cluster (watchdog).
> >
> > My PgPool standby server running on CentOS 6 with PgPool 4.0.5 is
> returning
> > an error that is saying "Could not get the password for user:postgres.
> > Unable to decrypt password from pool_passwd."
> >
> > I have a .pgpoolkey file and I have used *pg_enc* tool to generate the
> > SCRAM-SHA-256 encrypted password in *pool_passwd*.
>
> Could you show more logs of pgpool?
>
> Also you can find more details from the config example below:
> http://www.pgpool.net/docs/latest/en/html/example-cluster.html
>
>
> > What is wrong?
> >
> > Thank you in advance and best regards,
> >
> > Lionel Engel
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190605/87e55e09/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 369570 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190605/87e55e09/attachment-0001.obj>