Error 1023 - No pg_hba.conf entry

Last updated on Oct 26, 2022
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
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