Documentation

Setting up CDC for Postgres on RDS

To set up Change Data Capture (CDC) on Postgres you need to enable/configure Logical Replication. Before you start, please keep in mind:

Supported Postgres versions: 9.4.9+ and 9.5.4+

You can only set up CDC for Postgres on the RDS master instance.

The process requires a master instance reboot.

CDC for Postgres requires additional log storage. Though unlikely, failed replication due to a lost connection can cause logs to remain on the server. If logs do accumulate on the server, drop and recreate the replication slot. Notify Alooma if this happens so that we can recover any possible gaps in the data.

In order to replicate DELETE operations, the REPLICA IDENTITY parameter of each table being replicated must be set to DEFAULT, FULL, or BY INDEX (or anything but NOTHING).

Note

You cannot have multiple Postgres CDC inputs referencing the same replication slot.