How do I resolve the error - no pg_hba conf entry for host

3.2K Asked by ChrisEVANS in SQL Server , Asked on Sep 29, 2022

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:xampphtdocsxmastoolindex.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 persists. I restarted my XAMPP server several times but no changes appeared.

Answered by Christian Parsons

To resolve the error - no pg_hba conf entry for host -

This solution works for IPv4 / IPv6:

Edit pga_hba.conf File

Open up the pga_hba.conf file in your favorite editor:

  <strong>[root@localhost ~]#  nano /var/lib/pgsql/data/pg_hba.conf</strong>

Append To pga_hba.conf File

Append the following lines to the end of the pga_hba.conf file:

host all all ::1/128 md5

host all postgres 127.0.0.1/32 md5

Quit and save the editor of your preference.

Restart Service

Restart the postgresql service with the following command:

[root@localhost ~]# /etc/init.d/postgresql restart

Your Answer

Answer (1)

Ranjana

To resolve the error "No pg_hba.conf entry for host," you need to modify the pg_hba.conf file in your PostgreSQL installation to allow the host to connect. Follow these steps:

Locate the pg_hba.conf file: The pg_hba.conf file is typically located in the data directory of your PostgreSQL installation. The default path for this file is often /etc/postgresql//main/pg_hba.conf on Unix-based systems.

Edit the pg_hba.conf file: Open the pg_hba.conf file in a text editor with administrative privileges. You may need to use sudo or another

method to gain the necessary permissions.

  host    all             all             192.168.1.100/32         md5

Replace 192.168.1.100/32 with the IP address or range of the host that you want to allow to connect. You can also specify all to allow connections from any host.

Reload PostgreSQL: After saving your changes to the pg_hba.conf file, reload the PostgreSQL service to apply the changes. You can do this using a command like sudo systemctl reload postgresql on systems that use systemd.

Test the connection: Try connecting to the PostgreSQL server from the specified host to verify that the changes to pg_hba.conf are applied correctly.

By following these steps and adding an appropriate entry to the pg_hba.conf file, you should be able to resolve the "No pg_hba.conf entry for host" error and allow the specified host to connect to your PostgreSQL server.

Add an entry for the host: Add a new line to the pg_hba.conf file that specifies the authentication method, database, user, and IP address or range for the host. For example:

1 Week