PostgreSQL : cannot connect with a created role I am using PostgreSQL 11.3 on Fedora 30. With the postgres user, I can use psql or connect to the cluster in PgAdmin 4, but when I create another user, for example :

CREATE ROLE myuser LOGIN PASSWORD '…';


I always get an error like :

FATAL: password authentication failed for user "myuser"


I had a look at other similar questions here (including this one, but I don't have a case folding problem), and I still cannot make it work.

Here is my pg_hba.conf file :

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     scram-sha-256
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     scram-sha-256
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256


What I am doing wrong? Thank you for any help
I found where the problem was! I had changed the line

password_encryption = scram-sha-256


in /var/lib/pgsql/data/postgresql.conf

but had forgotten to uncomment it…