/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

7 votes132 views2 answers
Html to react converter
SQL
0 vote152 views1 answer
Mysql auto increment default value with prefix month and year
SQL
2 votes122 views4 answers
Duplicate record mysql
SQL
0 vote141 views1 answer
C# execute transact sql
SQL
0 vote155 views2 answers
Search stored procedures by name
SQL
10 votes144 views2 answers
What is database
SQL
0 vote133 views1 answer
Download mysql database to excel in android studio
SQL
13 votes124 views6 answers
Restart postgresql
SQL
0 vote128 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote182 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL