Sample Header Ad - 728x90

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

385 votes
12 answers
1418561 views
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 I found this answer that 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 persists. I restarted my XAMPP server several times but nothing changes. What do I need to change in pg_hba.conf?
Asked by Jin (3963 rep)
Dec 1, 2014, 10:54 AM
Last activity: Jul 26, 2023, 05:27 PM