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

by

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

enter image description here

  1. 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

enter image description here

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

    Example: ALTER ROLE postgres WITH PASSWORD 'root';

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

More Related Contents:

  1. Springboot 2.6.0 / Spring fox 3 – Failed to start bean ‘documentationPluginsBootstrapper’
  2. Setting active profile and config location from command line in spring boot
  3. How to pass JVM options from bootRun
  4. Maven profiles equivalent of Gradle
  5. Spring Boot 2.6.0 / Spring fox 3 – Failed to start bean ‘documentationPluginsBootstrapper’
  6. Configure ViewResolver with Spring Boot and annotations gives No mapping found for HTTP request with URI error
  7. Configuration using annotation @SpringBootApplication
  8. Integration Test with Spring Boot and Spock
  9. How to start Spring Boot app in Spock Integration Test
  10. Classpath resource not found when running as jar
  11. How to build sources JAR with Gradle?
  12. Spring Boot Multiple Datasource
  13. After Spring Boot 2.0 migration: jdbcUrl is required with driverClassName
  14. Spring Boot 2.0.x disable security for certain profile
  15. Problems passing system properties and parameters when running Java class via Gradle
  16. How to include JAR dependency into an AAR library
  17. No results returned by the Query error in PostgreSQL
  18. :app:dexDebug ExecException finished with non-zero exit value 2
  19. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  20. How can I register a secondary servlet with Spring Boot?
  21. Failed to import new Gradle project: failed to find Build Tools revision *.0.0
  22. Gradle – getting the latest release version of a dependency
  23. How to initialize MongoClient once in Spring Boot and use its methods?
  24. How do I run a spring boot executable jar in a Production environment?
  25. How to Get All Endpoints List After Startup, Spring Boot
  26. How do I create beans programmatically in Spring Boot?
  27. How can I run a Spring Boot application on port 80
  28. How do I disable resolving login parameters passed as url parameters / from the url
  29. How to customise Jackson in Spring Boot 1.4
  30. Where do resource files go in a Gradle project that builds a Java 9 module?

Leave a Comment