FATAL: PAM authentication failed for user "xxxxxx"

PostgreSQL
1

I’ve set up the user in an include file in pg_hba.conf
host database xxxxxxx all scram-sha-256

The user was created with
create user xxxxx;
alter user xxxxx with login password ‘yyyyyyyy’;

Other users I have set up in the past have worked OK.

I have double checked that the password is correct.

It shouldn’t even be using pam, should it?

What am I missing?

Jeremy

1 Like
2

I’ve found the problem. The username had some upper case characters.

Changing it to all lower case fixed it.

1 Like