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

[Bo Peng]

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