/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 vote215 views1 answer
Mysql last friday of current month
SQL
0 vote294 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote179 views2 answers
How to know the character set of an oracle databes
SQL
2 votes192 views2 answers
Change mysql password from command line
SQL
2 votes174 views1 answer
Mysql query unique column
SQL
9 votes191 views3 answers
Mysql run sql file
SQL
1 vote172 views1 answer
Mysql get character set
SQL
3 votes183 views3 answers
C# sql select
SQL
0 vote172 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote200 views1 answer
Oracle show grants on table
SQL