This role will allow the user to connect to the RDS instance and replicate data. Create a new role named replication_role with the REPLICATION LOGIN option.To set the role, connect to the RDS instance using an administrative account and run the following command: SET ROLE rds_superuser This role grants the superuser privileges required to perform administrative tasks on the RDS instance. Set the current session's role to rds_superuser.Access to a client that supports the PostgreSQL protocol, such as the 'psql' command-line tool.

Access to an Amazon Aurora PostgreSQL database.You will require the following before you begin: In this section, we will outline the steps to configure the rds_superuser role in Amazon RDS for PostgreSQL. The ' rds_superuser' role often used for administrative tasks such as creating and managing databases, users, and tables. The ' rds_superuser' is a special user in Amazon RDS for PostgreSQL that is used for maintenance operations on a database instance. Validate - Execute the following query as the DB master user to ensure that the wal level parameter is set to logical:Ĭonfiguring the RDS Superuser Role in Amazon RDS.You may need to reboot the writer db instnace in order to apply the new parameters values Select Continue, then Apply Immediately under Modification Scheduling. In the DB parameter group section, select the parameter group created in step 3. Navigate to the Databases section and select the CDC Postgres server you want, then click Modify. Rds.log_retention_period = 10080 # 7 days The following parameters must be modified: rds.logical_replication = 1 We can now change and enable some configurations in the parameter group associated with the current server. Give it a name (for example, Postgresql-rivery-cdc), and click Create.Įnter the parameter group you just created. On Aurora cluster, choose DB cluster parameter group as the parameter group type. Select the parameter group family that corresponds to your PostgreSQL server version. Under Parameter Groups, select Create Parameter Group.

To get started, go to the AWS RDS console.Ĭlick Services in the upper left corner, then RDS. Make sure to enable logical decoding for a PostgreSQL RDS instance following the PostgreSQL documentation.ĪWS RDS PostgreSQL v10+ comes pre-configured with pgoutput and logical replication, so all you have to do is enable them as follows:

Only UTF-8 character encoding databases are supported.

Log fetching will stop and the River will fail if the primary server fails or becomes detached. It won't work with warm or hot standby replicas.

Only the primary servers in the cluster can use logical decoding replication slots.

Rivery is unable to report DDL change events to the database as a result of this.

DDL changes are not supported by Logical Decoding.

Server and Database permissions are required to change server configuration (depending on the PostgreSQL cloud/on-prem provider).

Make sure you're running PostgreSQL 10 or higher.

Aws postgresql replication