Error 1023 - No pg_hba.conf entry

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

Potential Causes

  • Hevo is unable to access the PostgreSQL server.

  • Hevo’s IP address is not whitelisted.

Suggested Actions

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


Revision History

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

Date Release Description of Change
Jun-29-2026 NA Restructured and updated page content for accuracy and clarity.
Sep-05-2022 NA Brought this page under its respective Source documentation folder.
Aug-23-2021 1.70 New document.

Tell us what went wrong