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 pghba.conf entry for host '4X.XXX.XX.XXX', user 'userXXX', database 'dbXXX', SSL off in C:xampphtdocsxmastoolindex.php on line 37after it it says that i just need to add an entry in the pghba.conf file for that particular user.this is my pghba.conf file. # TYPE DATABASE USER ADDRESS METHOD# IPv4 local connections:local dbXXX userXXX md5host dbXXX userXXX XX.XXX.XXX.XXX md5host 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 md5but after doing so, the error still persist. I restarted my XAMPP server several times but no changes appears.Thanks in advance. Instructions for Debian users.Login as posgres user: $ sudo su - postgresGet the location of pghba.conf by quering the database: $ psql -c 'SHOW hbafile;'hbafile-/etc/postgresql/11/main/pghba.conf(1 row)Open pghba.conf: nano /etc/postgresql/11/main/pghba.confAdd configuration where it says 'Put your actual configuration here': # TYPE DATABASE USER CIDR-ADDRESS METHODhost all all 0.0.0.0/0 md5Logout to your user: $ exitlogoutRestart your postgres server for changes to take effect: $ sudo systemctl restart postgresql.
Add the IP address of the application (e.g., Jira) server to the pghba.conf and make sure that the method is not set to reject. You need to modify the xxx.xxx.xxx.xxx and put the IP address to allow connections. Libro tao te king pdf. # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all xxx.xxx.xxx.xxx md5.