[pgpool-general: 3872] Re: unable to auth with md5 and load balancing
Joshua D. Drake
jd at commandprompt.com
Wed Jul 15 07:50:51 JST 2015
On 07/14/2015 03:11 PM, Joshua D. Drake wrote:
> select passwd from pg_shadow where usename = 'postgres';
> grep postgres /etc/pgpool2/pool_passwd
> host all all 127.0.0.1/32 md5
> host all all 10.32.20.18/32 md5
> host all all 10.32.20.19/32 md5
Some follow up information:
.19 is the master
.18 is the slave
We are using streaming rep and everything including load balancing was
working fine until I changed the entries above from trust to md5. I am
testing by connecting from .18 to .19 with psql. I have tried using
PGPASSWORD= as well as .pgpass. Both achieve the same error.
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
More information about the pgpool-general