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

[Bo Peng]

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/