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
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.