Skip to main content
This page covers the Amazon RDS-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

  • Amazon RDS for PostgreSQL version 10 or above.
  • Connect to the primary instance. Logical replication only works on the primary.
  • Tables with a PRIMARY KEY.

​
Enable logical replication

1

Open the AWS RDS dashboard

Go to the AWS RDS console.
2

Create or open a DB parameter group

Create a DB parameter group that matches your PostgreSQL version (for example, postgres12). Skip this step if you already have one.
Creating a new parameter group for PostgreSQL in AWS RDS console
3

Set rds.logical_replication to 1

On the parameter group page, search for rds.logical_replication, select the row, click Edit parameters, and set the value to 1.
Setting rds.logical_replication parameter to 1 in the parameter group
4

Apply the parameter group

Apply the parameter group to the DB instance.
Applying the parameter group to the RDS PostgreSQL database
5

Reboot the instance

Modify the DB instance and wait until its status changes to pending-reboot, then reboot it to apply the new parameter group.
RDS instance in pending-reboot status after parameter group modification

​
Grant the RDS replication role

After creating the sync user (see the common setup), grant the managed RDS replication role instead of ALTER ROLE ... WITH REPLICATION: 
GRANT rds_replication TO integrateio;

​
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

PostgreSQL PrivateLink

Last modified on June 16, 2026