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

[Jon SCHEWE]

> > > 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
> 
> Thank you for the corrections. I had assumed that the format of the passwords.conf file would be the same as pgpool.conf and that it would use the keys from the conf file.
> However I see that this is generic for any database user so it makes perfect sense as it is.
> Now everything is working.
> Thank you!

Well, I had it working, but not with the configuration that I thought I had installed.
I've gone back and done more testing and found the following:

This works:
--- pgpool.conf ---
pool_passwd = 'passwords.conf'
sr_check_user = 'pgpool'
sr_check_password='password1'
health_check_user = 'pgpool'
health_check_password = 'password1'
recovery_user = 'postgres'
recovery_password = 'password2'


This reports 'Password does not match for user "pgpool".' in the postgresql log file.
--- pgpool.conf ---
pool_passwd = 'passwords.conf'
sr_check_user = 'pgpool'
sr_check_password=''
health_check_user = 'pgpool'
health_check_password = ''
recovery_user = 'postgres'
recovery_password = ''

--- passwords.conf ---
pgpool:TEXTpassword1
postgres:TEXTpassword2


This reports 'Password does not match for user "pgpool".' in the postgresql log file.
--- pgpool.conf ---
pool_passwd = 'passwords.conf'
sr_check_user = 'pgpool'
sr_check_password=''
health_check_user = 'pgpool'
health_check_password = ''
recovery_user = 'postgres'
recovery_password = ''

--- passwords.conf ---
pgpool:password1
postgres:password2


Jon Schewe