[pgpool-general: 3872] Re: unable to auth with md5 and load balancing

[Joshua D. Drake]

On 07/14/2015 03:11 PM, Joshua D. Drake wrote:
>
>
> select passwd from pg_shadow where usename = 'postgres';
>
> md57294f054631b20561f6004857f97481e
>
> grep postgres /etc/pgpool2/pool_passwd
>
> postgres:md57294f054631b20561f6004857f97481e
>
> pool_hba.conf:
>
> host    all     all             127.0.0.1/32            md5
> host    all     all             10.32.20.18/32          md5
>
> pg_hba.conf:
>
> 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.

Sincerely,

JD


-- 
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.