[Solved] cannot connect to postgres database remotely

[solooo7]

I cannot remotely connect to postgres database

 

database: api-master

username: api-master-user

host: johnny.heliohost.org

 

 

response I get :

 

psql.bin: FATAL:  no pg_hba.conf entry for host "137.97.155.**", user "api-master-user", database "api-master", SSL on
FATAL:  no pg_hba.conf entry for host "137.97.155.**", user "api-master-user", database "api-master", SSL off

 

[wolstech]

Krydos needs to enable remote access per database and per user. We don't have it turned on by default for security reasons.

 

What IP addresses need access, or do you want it from any IP?

[solooo7]

From any IP

[wolstech]

Moving so Krydos can enable this for you.

[solooo7]

I still get that error.

[wolstech]

Krydos hasn't turned it on yet. He'll post here when he does. It can take several hours.

[solooo7]

Thank you for the update.

[Krydos]

Remote access enabled.

[solooo7]

I'm still not able to connect.

I get that same error.

 

Server [localhost]: johnny.heliohost.org
Database [postgres]: api-master
Port [6969]: 5432
Username [postgres]: api-master-user
psql.bin: FATAL:  no pg_hba.conf entry for host "137.97.151.241", user "api-master-user", database "api-master", SSL on
FATAL:  no pg_hba.conf entry for host "137.97.151.241", user "api-master-user", database "api-master", SSL off
 

 

Edit: It works now.

I didn't know I had to add my username in front of database name and database_username.

Edited February 6, 2018 by solooo7