Prepare AWS Aurora and 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 database to work with RDI.
1. Create a parameter group
In the Relational Database Service (RDS) console, navigate to Parameter groups > Create parameter group. You will see the panel shown below:
Enter the following information:
Name | Value |
---|---|
Parameter group name | rdi-aurora-pg |
Description | Enable logical replication for RDI |
Engine Type | Aurora PostgreSQL |
Parameter group family | aurora-postgresql15 |
Type | DB Cluster Parameter Group |
Select Create to create the parameter group.
2. Edit the parameter group
Navigate to Parameter groups in the console. Select the rdi-aurora-pg
group you have just created and then select Edit . You will see this panel:
Search for the rds.logical_replication
parameter and set its value to 1. Then,
select Save Changes.
3. Select the new parameter group
Scroll down to Additional Configuration. Set the DB Cluster Parameter Group
to the value rdi-aurora-pg
that you have just added: