[pgpool-general: 8330] Re: Problems with pool_passwd

[Bo Peng]

Hello,

> > Hello,
> > 
> > > pool_passwd = 'passwords.conf'
> > > This reports 'Password does not match for user "pgpool".' in the postgresql log file.
> > 
> > If you are using a relative path, please make sure passwords.conf exists in the same directory as pgpool.conf.
> > Otherwise, you need to specify an absolute path.
> > 
> > https://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-POOL-PASSWD
> 
> Both passwords.conf and pgpool.conf are in /etc/pgpool-II
> 
> I can verify the file is being read by removing entries from the file and then I get an error from postgresql that an empty password was sent.

I could not reproduce this issue.
Could you connect to PostgreSQL using "pgpool" user and password "password1".

Could you share the following information to reproduce this issue?

- pgpool.conf
- pool_hba.conf
- passwords.conf
- pg_hba.conf
- PostgreSQL version and Pgpool-II version
- the command to set password for pgpool user

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
https://www.sraoss.co.jp/