Answers for "sqlstate[08006] [7] 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')"

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')

Step 1: Find file postgresql.conf in C:Program FilesPostgreSQL13data then set password_encryption = md5
Step 2: Find file pg_hba.conf in C:Program FilesPostgreSQL13data 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.

Posted by: Guest on October-19-2021

Source

Code answers related to "sqlstate[08006] [7] 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')"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "sqlstate[08006] [7] 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')"

Code answers related to "sqlstate[08006] [7] 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')"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us