[Solved] Remote Access to PostgreSQL Database

[addike]

I'm using the following command to connect to my remote postgresql database.

$ psql -h johnny.heliohost.org -p 5432 -U addike_official -W addike_ConnectionServerDB
Password:
psql: error: FATAL:  no pg_hba.conf entry for host "ip address over here", user "addike_official", database "addike_ConnectionServerDB", SSL off

Credentials:

Host: johnny.heliost.org
Username: addike_official
Database: addike_ConnectionServerDB
Port: 5432
Password: . . . 

Can remote access be enabled for this database please? Thanks!

[Luigi123]

Absolutely!

 

This can be done by our root admin Krydos which I’m going to escalate to him right now.

 

Escalating

[addike]

Thank you so much! May I know when it will be ready? Thanks in advance!

Edited February 5, 2021 by addike

[Krydos]

Remote access enabled.

[addike]

Thanks!