[Solved] Request To Connect Remotely To Postgresql

[ilich]

Have a nice day. I have the problem that I can't connect remotely to the postgres database I've made

 

My connection parameters are

 

database: ilich_secultura

user: ilich_secultura_user

host: johnny.heliohost.org

 

And the command from debian I'm using is:

 

psql -h johnny.heliohost.org -p 5432 -U ilich_secultura_user -W pwd -d ilich_secultura

 

Then the connection responds:

psql: FATAL: no pg_hba.conf entry for host "your ip", user "ilich_secultura_user", database "ilich_secultura", SSL off

 

I need help. Thanks

 

**edit: host is johnny NOT jhonny. But still not working

[Krydos]

You may now access the postgresql database ilich_secultura using the user ilich_secultura_user from any IP address. Let us know if it still isn't working.

[ilich]

Yes. Now I can connect. You are great. Thank you

[Luigi123]

Moved to Customer Service.

 

Glad we can help.

 

If you have any questions or if you need help anything, feel free to post it on the forums.

 

Marking this Thread as Solved.

[wolstech]

@heliohob: I moved your post to its own topic: https://www.helionet.org/index/topic/29769-remote-postgres-access/