Error 1023 - No pg_hba.conf entry

Last updated on Oct 26, 2022

Potential Causes

Whitelist Hevo’s IP addresses:
1. Navigate to the PostgreSQL configuration file, pg_hba.conf. This file is generally found in the path: /etc/postgresql/<version>/main/.
2. Add the Hevo IP addresses for your region or 0.0.0.0 to allow all IPs to connect:
```
    host    all             user_name           0.0.0.0/0              md5
```
Invite another team member with the required privileges to set up the Pipeline. Read Inviting and Moderating Team Members.

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Sep-05-2022	NA	Brought this page under its respective Source documentation folder.
Aug-23-2021	1.70	New document.

Error Code	1023
Error Message Text(s)	- FATAL: no pg_hba.conf entry for replication connection from host “{hostname}”, user “{database_user}”, SSL on.