Overview

In this module, we will configure Aurora PostrgreSQL with one node (reader and writer). Furthermore, we will configure PostgreSQL pg_logical extension to replicate to another PostgreSQL RDS. So let's get started.

Configure the publisher / provider

Firstly, we will start with the creation of the Aurora PostgreSQL, which will acts as a Publisher / Provider

Aurora PostgreSQL

To do

This code will create Aurora PostgreSQL with pg_logical extension enabled and furthermore, it will execute the SQL template below:

SQL Template Source

These are OF COURSE, test settings, BUT they will setup a pg_logical extension and start the node as publisher/provider Then, let's configure the Subscriber

Configure the Subscriber

The following code, will configure RDS PostgreSQL and it will create some Demo structure for the pg_logical:

Configure Subscriber

As before, the code will create RDS PostgreSQL with all the options for pg_logical. It will also execute the SQL template below:

SQL Template Destination