/SQL/SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')

SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')

Step 1: Find file postgresql.conf in C:\Program Files\PostgreSQL\13\data then set password_encryption = md5
Step 2: Find file pg_hba.conf in C:\Program Files\PostgreSQL\13\data then change all METHOD to md5
Step 3: Open command line (cmd,cmder,git bash...) and run psql -U postgres then enter your password when installed postgres sql
Step 4: Then change your password by run ALTER USER postgres WITH PASSWORD 'new-password' in command line
Final: Restart service postgresql-x64-13 in your Service.

Source: stackoverflow.com

Similar codes

0 vote183 views1 answer
Sql string length postgresql
SQL
0 vote199 views1 answer
OFFSET consulta mysql
SQL
4 votes207 views2 answers
What is table in sql
SQL
13 votes183 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote158 views1 answer
Psql kill pid
SQL
5 votes196 views2 answers
Oracle tables with column name
SQL
-2 votes204 views2 answers
Union all in sql
SQL
0 vote188 views1 answer
How to get n result in sql
SQL
0 vote214 views1 answer
How to combine rows in sql server procedure
SQL
0 vote198 views1 answer
How to get specific salary in sql
SQL