DataGrip Postgres SSL error: sun.security.validator.ValidatorException

Question

DataGrip won't connect to my Postgres instance, but I can connect fine via psql on the terminal:

psql -h dbhost.com reps username
>Password for user... (connects)

However, IntelliJ DataGrip throws:

Connection to [email protected] failed.
SSL error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

The connection string it uses is jdbc:postgresql://dbhost.com:5432/dbname

Answer 1

Try disabling the SSL checkbox in the SSH/SSL tab in your database's property window.

Then append ?sslmode=require to the URL in the General tab so that it reads something like: jdbc:postgresql://localhost:5432/reps?sslmode=require

Answer 2

Change sslmode to disable in Advanced tab in you database's property window