I have a cluster that consists of:

  1. pgpool
  2. master
  3. slave

Using pgpool-II version 4.3.2 and Postgres 14.4

Several users have been created, all are authenticated through pgpool. There was a need to create new users.

In pool_passwd I create entries in this way:

pg_enc -m -f /etc/pgpool2/pgpool.conf -i users.txt

(in users.txt there are user logins and passwords)

When connecting with Dbeaver

ERROR: backend authentication failed
Details: backend response with kind 'E' when expecting 'R'

pg_md5 -m --config-file="/etc/pgpool2/pgpool.conf" -u "user" "pass"

ERROR: failed to authenticate with backend using SCRAM
Details: valid password not found


host    all         all          scram-sha-256
host    all         postgres             scram-sha-256

local   all         all                               md5
local   all         postgres                          scram-sha-256

host    all         all          md5
host    all         all         ::1/128               md5
host    all         all             md5

local all all    trust
host  all all trust

What could be the problem?

2 Answers 2


Happyman Chiu's answer made my life a lot easier. I was trying to get PMM to connect to Pgpool and tried simply making pool_hba trust any connections from pmm_user, with no success. Just deferring to the backends pg_hba is the fix for me.

  • 1
    You should tick his answer then. Commented Apr 19 at 8:48


enable_pool_hba = off
allow_clear_text_frontend_auth = on
pool_passwd = ''

this config works for me.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.