/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 vote150 views2 answers
Sql drop multiple columns if exists
SQL
0 vote141 views1 answer
Mysql xampp reset root password
SQL
2 votes135 views1 answer
Oracle calculated column
SQL
0 vote141 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes131 views1 answer
Postgresql if null then 0
SQL
0 vote142 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
5 votes161 views1 answer
Oracle nls parameters
SQL
0 vote142 views1 answer
How should I pass a table name into a stored proc?
SQL
10 votes141 views2 answers
Tsql merge example
SQL
0 vote142 views1 answer
Mysql grant grant option
SQL