Posted On: Jul 6, 2023
Amazon Relational Database Service (Amazon RDS) Multi-AZ Deployments with two readable standbys now supports logical replication. With logical replication, you can stream data changes from Amazon RDS for PostgreSQL to other databases for use cases such as data consolidation for analytical applications, change data capture (CDC), replicating select tables rather than the entire database, or for replicating the data between different major versions of PostgreSQL.
Amazon RDS for PostgreSQL supports the streaming of data changes using PostgreSQL's logical replication. You can now set up logical replication to send data from your Amazon RDS for PostgreSQL Multi-AZ deployments with two readable standbys to other data systems, or receive changes from other systems into your Amazon RDS for PostgreSQL Multi-AZ deployments with two readable standbys. In addition to the native PostgreSQL logical replication, Amazon RDS for PostgreSQL Multi-AZ deployments with two readable standbys supports the pglogical and wal2json extensions for streaming changes for use in other systems.
Logical replication for Multi-AZ Deployments with two readable standbys is supported on Amazon RDS for PostgreSQL version 14.8-R2 and higher, and 15.3-R2 and higher. For a full list of regional availability and supported engine versions, refer the Amazon RDS User Guide.
Learn more about setting up and using logical replication on Amazon RDS for PostgreSQL Multi-AZ deployments with two readable standbys in the Amazon RDS User Guide. Create or update a fully managed Amazon RDS Multi-AZ database with two readable standby instances in the Amazon RDS Management Console.