Posted on 2019-04-17

No pg_hba.conf entry for host, SSL off error on dbeaver heroku postgres connection

if your dbeaver connection to heroku postgres db fails with this message: “FATAL: no pg_hba.conf entry for host “...”, user “...”, database “...”, SSL off” 

you will need to:

  1. open "Advanced settings" in dbeaver,
  2. check "Use SSL"
  3. add "org.postgresql.ssl.NonValidatingFactory" to "SSL Factory" field


PS.

In Linux/Mac run the command 

export PGSSLMODE=require 

before running the pg_restore command.