Amazon Aurora with PostgreSQL Compatibility Supports Logical Replication

Posted on: Mar 28, 2019

Amazon Aurora with PostgreSQL compatibility now supports logical replication. With logical replication, you can replicate data changes from your Aurora PostgreSQL database to other databases using native PostgreSQL replication slots, or data replication tools such as the AWS Database Migration Service (DMS). Logical replication is supported with Aurora PostgreSQL versions 2.2.0 and 2.2.1, compatible with PostgreSQL 10.6.

To enable logical replication with Aurora PostgreSQL, set up logical replication slots on your instance and stream changes from the database through these slots. This is enabled by setting the parameter rds.logical_replication to 1; you can set this parameter in just a few clicks in the Amazon RDS Management Console. The rds_replication role, assigned to the master user by default, can be used to grant permissions to manipulate and stream data through replication slots. This feature also enables Aurora PostgreSQL to be used as a source for AWS Database Migration Service (DMS). You can learn more about using logical replication with Aurora PostgreSQL in the Aurora documentation.

Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. For more information, please visit the Amazon Aurora product page, and see the AWS Region Table for complete regional availability.