Prepare AWS Aurora PostgreSQL/AWS RDS PostgreSQL for RDI

Prepare AWS Aurora PostgreSQL databases to work with RDI

Follow the steps in the sections below to prepare an AWS Aurora PostgreSQL or AWS RDS PostgreSQL database to work with RDI.

Create and apply parameter group

RDI requires some changes to database parameters. On AWS RDS and AWS Aurora, you change these parameters via a parameter group.

1. In the Relational Database Service (RDS) console, navigate to Parameter groups > Create parameter group. Create a parameter group with the following settings:

   Name	Value
   Parameter group name	Enter a suitable parameter group name, like rdi-aurora-pg or rdi-rds-pg
   Description	(Optional) Enter a description for the parameter group
   Engine Type	Choose Aurora PostgreSQL for Aurora PostgreSQL or PostgreSQL for AWS RDS PostgreSQL.
   Parameter group family	Choose aurora-postgresql15 for Aurora PostgreSQL or postgresql13 for AWS RDS PostgreSQL.

   Select Create to create the parameter group.

2. Navigate to Parameter groups in the console. Select the group you have just created and then select Edit. Change the following parameters:

   Name	Value
   rds.logical_replication	1

   Select Save Changes to apply the changes to the parameter group.

3. Go back to your database on the RDS console, select Modify and then scroll down to Additional Configuration. Set the DB Cluster Parameter Group to the group you just created.

   Select Save changes to apply the parameter group to your database.

4. Reboot your database instance. See Rebooting a DB instance within an Aurora cluster or Rebooting a DB instance (RDS) for more information.

Create Debezium user

The Debezium connector needs a user account to connect to PostgreSQL. This user must have appropriate permissions on all databases where you want Debezium to capture changes.

1. Connect to PostgreSQL as the postgres user and create a new user for the connector:

   CREATE ROLE <username> WITH LOGIN PASSWORD '<password>' VALID UNTIL 'infinity';
   

   Replace <username> and <password> with a username and password for the new user.

2. Grant the user the necessary replication permissions:

   GRANT rds_replication TO <username>;
   

   Replace <username> with the username of the Debezium user.

3. Connect to your database as the postgres user and grant the new user access to one or more schemas in the database:

   GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <username>;
   

   Replace <username> with the username of the Debezium user and <schema> with the schema name.