HelioHost Posted March 23, 2019 Posted March 23, 2019 Username: harryahl, Server: Johnny, Main domain: harryahl.heliohost.org I am having a very similar issue to the person in this post: https://www.helionet.org/index/topic/28141-solved-request-to-connect-remotely-to-postgresql/ I am using R to access with these parameters: database= "harryahl_hrsamplepostgresql"host = "johnny.heliohost.org"user = "harryahl" And I get this error: Error in connection_create(names(opts), as.vector(opts)) : FATAL: no pg_hba.conf entry for host "70.36.251.250", user "harryahl", database "harryahl_hrsamplepostgresql", SSL off Please advise. I appreciate your help. Harry
wolstech Posted March 23, 2019 Posted March 23, 2019 You have to request remote access for Postgres. We don't allow it by default. For fastest response, we suggest you post on the forums requesting it (we can't escalate emails, so they sometimes sit for a while before the admin who handles this sees the request). We need to know which database and database user will need access, and what IP will be connecting (or we can allow all).
HelioHost Posted March 28, 2019 Author Posted March 28, 2019 Thank you for the response. Where should I post this information? On 2019-03-23 06:42, Heliohost Support wrote:> You have to request remote access for Postgres. We don't allow it by > default.> For fastest response, we suggest you post on the forums requesting it> (we can't escalate emails, so they sometimes sit for a while before> the admin who handles this sees the request). We need to know which> database and database user will need access, and what IP will be> connecting (or we can allow all).> > You may view the status of your ticket by visiting:> > https://www.helionet.org/index/index.php?showtopic=35400> > Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/
Flaze Posted March 28, 2019 Posted March 28, 2019 You'll need to post it on https://www.helionet.org/index/forum/45-customer-service/.
Krydos Posted March 28, 2019 Posted March 28, 2019 Don't bother. The postgresql user harryahl has been granted remote access from any IP to harryahl_hrsamplepostgresql.
Recommended Posts