lundi 1 décembre 2014

connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host


Hello I am trying to run a website sent to me but after doing so this error appeared



connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "4X.XXX.XX.XXX", user "userXXX", database "dbXXX", SSL off in C:\xampp\htdocs\xmastool\index.php on line 37


after Googling it it says that i just need to add an entry in the pg_hba.conf file for that particular user. this is my pg_hba.conf file.



# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
local dbXXX userXXX md5
host dbXXX userXXX XX.XXX.XXX.XXX md5
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5


but after doing so, the error still persist. I restarted my XAMPP server several times but no changes appears. Thanks in advance





Aucun commentaire:

Enregistrer un commentaire