/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

79 votes392 views6 answers
Grepper code
SQL
0 vote238 views2 answers
How to count codition
SQL
0 vote212 views1 answer
Pip install mysqlclient error
SQL
0 vote209 views2 answers
How to find sql server agent jobs related to a database
SQL
21 votes220 views4 answers
Oracle add column
SQL
3 votes214 views2 answers
Sql random integer
SQL
19 votes186 views1 answer
Sqrt(-1)
SQL
0 vote211 views1 answer
How to find unique key in sql
SQL
0 vote202 views1 answer
Describe in sqlite3
SQL
0 vote217 views1 answer
How to reset the database value in SQL server
SQL