Skip to main content
This page covers the self-hosted-specific steps to prepare your PostgreSQL instance for ELT & CDC. After completing them, follow the common setup (sync user grants, heartbeat table, publication, and replication slot) on the PostgreSQL source for ELT & CDC page.

​
Requirements

  • PostgreSQL version 10 or above.
  • Connect to the primary instance. Logical replication only works on the primary.
  • Tables with a PRIMARY KEY.
  • Network access from Integrate.io to your database (direct, SSH tunnel, or reverse SSH tunnel).

​
Enable logical replication

Set wal_level to logical:
Restart the database for the change to take effect.

​
Allow the sync user to replicate

In pg_hba.conf, ensure the sync user has both regular and replication connection entries from the Integrate.io source IPs, for example:
Reload PostgreSQL after editing pg_hba.conf. After creating the sync user (see the common setup), grant the replication attribute:

​
Next: common setup

Continue with the canonical PostgreSQL setup for the remaining steps — sync user privileges (USAGE, SELECT, REFERENCES), heartbeat table, publication, and replication slot:

PostgreSQL source for ELT & CDC

SSH Tunnel

Reverse SSH Tunnel

Last modified on October 5, 2026