[Solved] Postgresql SCRAM authentifcation

[solution]

You can change the postgresql configuration to md5.

 

[Workaround]

1. pg_hba_conf

cd C:\Program Files\PostgreSQL\13\data\pg_hba_conf

Change the method from scram-sha-256 to md5

 

2. postgresql.conf

cd C:\Program Files\PostgreSQL\13\data\postgresql.conf

Change the password_encryption from scram-sha-256 to md5

3. reload PostgreSQL

4. change the password of the user to get an MD5 encrypted password

 

good luck!