CODEWITHSUNDEEP
postgresqlauthenticationmd5postgresql-14pgpool
yeonjoo choi
yeonjoo choi

Reputation: 1

Authentication Failure with pgpool using md5

I am using pgpool 4.3.6 with postgreSQL 14.

The authentication method is set to md5. When attempting to authenticate, I encounter the following error:

FATAL:  authentication failed for user ""
DETAIL:  username and/or password does not match

I've verified that both pg_hba.conf and pool_hba.conf are configured to use md5 for authentication.

Additionally, the password_encryption setting in postgresql.conf is set to md5, as shown below:

show password_encryption;
 password_encryption
---------------------
 md5
(1 row)

I also set a password in the pcp.conf file that matches the one in the pool_passwd.

Does anyone have any insights on what might be causing this authentication issue?

Upvotes: 0

Views: 202

Answers (0)

Related Questions