Error 1023 - No pg_hba.conf entry

Error Code 1023
Applies To All PostgreSQL Sources
Category Communication
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
Aug-23-2021 1.70 New document.
Last updated on 06 Sep 2021