I am trying to use pgAdmin to connect to a Postgresql server hosted by Elephantsql. However, I keep getting the error
no pg_hba.conf entry for host:
no pg_hba.conf entry for host "220.127.116.113", user "db_user", database "db_name", SSL on FATAL: no pg_hba.conf entry for host "xxx.xx.xxx.xxx", user "hcexhbhx", database "postgres", SSL off
After doing some research, I edited my
# TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 18.104.22.168/24 md5 (new entry) host all all 0.0.0.0/0 md5 (new entry) # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. #local replication uzrrrrd trust #host replication uzrrrrd 127.0.0.1/32 trust #host replication uzrrrrd ::1/128 trust
And I added a line to my
And I restarted postgresql before attempting to connect again.
However, I'm still getting the
no pg_hba.conf entry for host error.
Does anyone know what I might be doing wrong?
Thank in advance!