/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 vote212 views1 answer
Search for replace in mysql
SQL
1 vote230 views1 answer
Mariadb get column names from table
SQL
10 votes208 views6 answers
Sql between
SQL
53 votes385 views6 answers
How to install mysql ubuntu
SQL
0 vote219 views1 answer
Sqlite trim
SQL
6 votes206 views1 answer
To count number of rows in SQL table
SQL
5 votes207 views1 answer
Oracle get foreign keys on table
SQL
0 vote205 views2 answers
Sql 2 way of select unique
SQL
2 votes206 views1 answer
Sql percentage with % rounded down
SQL
2 votes209 views6 answers
In operator in sql
SQL