Postgresql – PgPool fails to auth in master_slave mode

pgpoolpostgresql

We have two PostgreSQL servers running in master-slave streaming replication mode, behind pgpool.

When we activate master_slave mode in pgpool.conf, we get following error:

do_md5 failed in slot 1

When we add a host with the md5 method in pool_hba.conf, we're getting this error:

md5 token is invalid

Without master_slave mode, pgpool connects successfully. Where to dig?

Best Answer

Here are steps wich helped me:

  1. You need to check pgpool.conf for enable_pool_hba = on.

  2. Here is a table with description of errors on pg_hba.conf and pool_hba.conf: FAQ

  3. Also check md5 hash for pool_passwd, I got it from database using query:

    select passwd from pg_shadow where usename = 'username';

Related Question