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

Joshua D. Drake jd at commandprompt.com
Wed Jul 15 07:11:15 JST 2015

select passwd from pg_shadow where usename = 'postgres';


grep postgres /etc/pgpool2/pool_passwd



host    all     all               md5
host    all     all             md5


host    all     all             md5


Jul 14 15:06:49 ly19 pgpool[58186]: connection received: 
host= port=34276
Jul 14 15:06:49 ly19 pgpool[58186]: pool_read_message_length: message 
length (8) in slot 1 does not match with slot 0(12)
Jul 14 15:06:49 ly19 pgpool[58186]: Failed to read the authentication 
packet length. This is likely caused by the inconsistency of auth method 
among DB nodes. In this case you can check the previous error messages 
(hint: length field) from pool_read_message_length and recheck the 
pg_hba.conf settings.

I am not sure what I am missing here?



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 mailing list