I have been using JetBrains new 0XDBE to do some database development on PostgreSQL.  I installed PostgreSQL myself on my linux VPS and immediately got frustrated with the following error:

java.sql.SQLException: SSL error: sun.security.validator.ValidatorException: PKIK path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.


Data Sources and Drivers


The error is confusing but luckily the fix is simple.

In the Data Source settings add: org.postgresql.ssl.NonValidatingFactory to the sslfactory setting in the Advanced tab.



After adding that setting click apply and then test the connection again and you should be good to go.