How to Connect to Postgres Db Due to the Authentication Type 10 Is Not Supported

Unable to connect to Postgres DB due to the authentication type 10 is not supported

I solved similar issue by applying below steps in PostgreSQL Version 13:

1. Change password_encryption to md5 in postgresql.conf

Windows: C:\Program Files\PostgreSQL\13\data\postgresql.conf
GNU/Linux:           /etc/postgresql/13/main/postgresql.conf

2. Change scram-sha-256 to md5 in pg_hba.conf

Windows: C:\Program Files\PostgreSQL\13\data\pg_hba.conf
GNU/Linux:           /etc/postgresql/13/main/pg_hba.conf

host    all             all             0.0.0.0/0               md5

3. Change Password ( this restore password in md5 format).

   Example: ALTER ROLE postgres WITH PASSWORD 'root';

4. Make sure you set listen_addresses = '*' in postgresql.conf if you are working non production environment.

DBeaver PostgreSQL Database - SCRAM authentication is not supported by this driver

I had same error and in my situation I had old database drivers. These steps fixed it for me:

• Go to Database Driver Manager
• Select PostgreSQL (either double click or single select and then "Edit ...")
• Click on "Download/Update"
• Choose newer version (see bold version text) e.g. 42.2.18 for org.postgresql:postgresql:RELEASE
• Press "Download"

Related Topics