Open nguiard opened 2 years ago
any update?
I had this issue too but I found this StackOverflow post that describes the additional procedure you have to follow before you can switch between md5 and scram-sha-256: https://stackoverflow.com/a/64317399/1671320
Essentially you have to change password_encryption
in postgresql.conf
and then update your Postgres user passwords and then enable scram-sha-256 in pg_hba.conf
. Connections are working for me after this procedure.
Trying to connect with a
scram-sha-256
password fails (error: password authentication failed for user "<user>"
), whilemd5
works.Environmnent:
Steps to reproduce:
psql
:create user someuser password 'secret';
create database somedb owner someuser;
psql postgres://someuser:secret@localhost:5432/somedb
error: password authentication failed for user "someuser"