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