DbVisualizer is a fantastic cross-platform database client, and I wanted to connect it to a Heroku Postgres instance I just spun up.
Postgres on Heroku is SSL-enabled with self-signed certificates, so for the connection to work in DbVisualizer, I had to define two special driver properties for the PostgreSQL JDBC driver:
- ssl was set to true
- sslfactory was set to org.postgresql.ssl.NonValidatingFactory
Observe the screenshot below to identify the configuration of the properties:
Sources: http://bartling.blogspot.com/2013/06/connecting-dbvisualizer-to-heroku.html and https://devcenter.heroku.com/articles/connecting-to-heroku-postgres-databases-from-outside-of-heroku