Jump to content


You can find the new forum at https://www.helionet.org/

vonhut85

Member Since 26 Jun 2021
Offline Last Active Jun 26 2021 08:37 PM
-----

Topics I've Started

[Solved] postgres remote access

26 June 2021 - 11:20 AM

I cannot remotely connect to postgres database

 

database: vonhut85_Pharmacy

username: vonhut85_root

host: vonhut85.heliohost.us

 

 

response I get from Navicat:

FATAL:  no pg_hba.conf entry for host "171.235.187.130", user "vonhut85_root", database "vonhut85_Pharmacy", SSL off.

I'm google search help
 

Add or edit the following line in your postgresql.conf :

listen_addresses = '*'

Add the following line as the first line of pg_hba.conf. It allows access to all databases for all users with an encrypted password:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 0.0.0.0/0 md5

Restart Postgresql after adding this with service postgresql restart or the equivalent command for your setup.