[Solved] Postgres external access

[mbo]

Hi,

I have the following error when trying to remotely access my Postgres database

no pg_hba.conf entry for host "XX.XX.XX.XX", user "mbo_agency", database "mbo_agency_services", SSL on

How can I grant access?

Best regards

[KazVee]

This support request is being escalated to our root admins who can grant remote access.

Remote access to PostgreSQL is not granted by default, but an admin can set it up on request. Please refer to the detailed troubleshooting page here for a longer explanation: https://wiki.helionet.org/common-errors/postgres-remote-connection-error

If you wanted to enable remote access yourself, you'd need to use a MariaDB database, where you can grant the remote access rights when you create the DB.

[Krydos]

Remote access enabled.

host=65.19.154.90
port=5432
user=mbo_agency
dbname=mbo_agency_services
password=<set in Plesk>

 

[mbo]

Thanx a lot @Krydos