To connect Pgsql in Heroku, SSL is required. If not, an error message will be given:
FATAL: no pg_hba.conf entry for host "75.168.4.146", user "rphbqggxeokuxl", database "dc008iqk0rq4j5", SSL off
To make it with DBeaver:
- click the "SSL" tab on connection proper.
- choose a Factory for "SSL Factory" in the "Advanced" section.
DONE!!!