How to use scram-sha-256 in Postgres 10 in Debian? Getting "FATAL: password authentication failed"
The fine manual says:
To upgrade an existing installation from
md5
toscram-sha-256
, after having ensured that all client libraries in use are new enough to support SCRAM, setpassword_encryption = 'scram-sha-256'
inpostgresql.conf
, make all users set new passwords, and change the authentication method specifications inpg_hba.conf
toscram-sha-256
.