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.