How to use scram-sha-256 in Postgres 10 in Debian? Getting "FATAL: password authentication failed" How to use scram-sha-256 in Postgres 10 in Debian? Getting "FATAL: password authentication failed" postgresql postgresql

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 to scram-sha-256, after having ensured that all client libraries in use are new enough to support SCRAM, set password_encryption = 'scram-sha-256' in postgresql.conf, make all users set new passwords, and change the authentication method specifications in pg_hba.conf to scram-sha-256.