[pgpool-general: 8271] Re: Problems with pool_passwd
Bo Peng
pengbo at sraoss.co.jp
Thu Jun 30 10:39:05 JST 2022
Hello,
> I'm having some trouble using pool_passwd with pgpool-II 4.3.2.
> I'm using the attached pgpool.conf file where I have specified that the pool_passwd file is named "passwords.conf".
> This file exists and is readable only by the postgres user, which is the same user pgpool-II is running as.
> This file contains:
> sr_check_password = 'TEXTpass1'
> health_check_password = 'TEXTpass2'
> recovery_password = 'TEXTpass3'
The format of "passwords.conf" should be:
<username>:<password>
If your pgpool.conf settings are:
sr_check_user = 'pgpool'
sr_check_password=''
health_check_user = 'pgpool'
health_check_password = ''
recovery_user = 'postgres'
recovery_password = ''
passwords.conf should be:
pgpool:TEXTpasswordofpgpool
postgres:TEXTpasswordofpostgres
Best regards,
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
https://www.sraoss.co.jp/
More information about the pgpool-general
mailing list