Heroku PostgreSQL and DBVisualiser connection using SSL

I occasionally use Heroku to deploy webapps on the cloud combined with a Postgres database to store my relational data

I recently found a multi-platform polyglot SQL client that I could use with my MAC, this product is called DbVisualiser

However since Heroku requires an SSL security on external connections after providing the usual database connection properties (url, username, password) when I tried to connect through DbVisualiser I was getting the error message :

FATAL: no pg_hba.conf entry for host "", user "u4b1uljsil33m2", database "de9td8cv06p4se", SSL off

After playing a bit with the different options and reading the Postgres JDBC driver over here I found out that you can provide an Non Validating SSL factory in the connection properties to satisfy Heroku's SSL requirements

In order to configure the SSL properties in DbVisualiser you need to edit the following SSL properties in the Properties tab :

  • SSL : true
  • sslfactory : org.postgresql.ssl.NonValidatingFactory

By providing these 2 properties you should be able to connect to your Heroku database without any problems

Docker copy images between hosts

Copying docker images (import/export) between hosts Sometimes it's useful to export a local docker image to another host without going...