[Solved] Heliohost Johhny - I Can't Remote Connect To Postgres

[hostdb]

Hello,

I need to resolve the problem with remote connection with Postgres database.
An error occurred:
Cannot establish a connection to jdbc:postgresql://johnny.heliohost.org:5432/hostdb_allotments using org.postgresql.Driver
(FATAL: no pg_hba.conf entry for host <my ip> , user "hostdb_administrator", database "hostdb_allotments", SSL off)

I use:
host name: johnny.heliohost.org
port: 5432
database name: hostdb_allotments
username: hostdb_administrator
password: <correct>

I direct request to root admin.
I need to access from all IPs to database.

 

Best Regards

Edited November 28, 2017 by hostdb

[Krydos]

I need to resolve the problem with remote connection

It's not a problem. Remote access to postgresql databases are intentionally blocked for security. Most users don't want or need remote access.

 

Remote access enabled.