/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

1 vote349 views1 answer
Display total number of tables in mysql
SQL
7 votes357 views1 answer
Append column sql
SQL
3 votes406 views3 answers
1396(hy00) mysql error
SQL
0 vote360 views1 answer
Connect to ssms with python
SQL
0 vote405 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote357 views1 answer
Mysql filter based on datediff
SQL
1 vote365 views1 answer
Sql group by sum with condition
SQL
0 vote351 views1 answer
Low level operator in dbms
SQL
1 vote406 views1 answer
Create email address from first and last name in sql
SQL
2 votes372 views1 answer
Mysql now format
SQL