Setting up AWS Aurora Cloud for PostgreSQL for CDC (Change data capture)

You can use the AWS master user account for the PostgreSQL database instance as the user for the AWS Aurora Cloud for PostgreSQL source endpoint. The master user account has the required roles that allow it to set up change data capture (CDC).

If you prefer not to use the master user account, the account you wish to use must have the rds_superuser role and the rds_replication role. The rds_replication role grants permissions to manage logical slots and to stream data using logical slots.

To enable logical replication for an AWS Aurora Cloud PostgreSQL database instance:

1. Create a new DB cluster parameter group with the following configuration:
   1. Set the rds.logical_replication parameter in the database parameter group to 1.
   2. max_wal_senders – The number of tasks that can run in parallel.
   3. max_replication_slots – Every connection (i.e. task) creates a new slot; this parameter configures the amount of simultaneous connections that can be established to the database.

2. Link the AWS Aurora Cloud cluster DB to the DB cluster parameter group.

   Information note

   If the attrep_intercept_ddl stored procedure is not being created in the default schema, you need to specify the schema name in the Create DDL artifacts under schema field.