/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 vote398 views1 answer
Oracle concat datetime
SQL
0 vote361 views1 answer
Add computed column to table sql server
SQL
3 votes365 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote346 views3 answers
Get count of null in column sql
SQL
0 vote360 views1 answer
Sql server change schema of a table
SQL
0 vote348 views2 answers
How to list all values of a column that start with a letter in sql
SQL
5 votes364 views1 answer
Oracle list functions
SQL
1 vote348 views1 answer
Sql list all procedures
SQL
1 vote361 views1 answer
Rails run native ssql query
SQL
2 votes384 views1 answer
Q operator in plsql
SQL