Announcing open sourcing pgactive: active-active replication extension for PostgreSQL

Today, AWS announces the open sourcing of pgactive, a PostgreSQL extension for active-active replication. pgactive lets you use asynchronous active-active replication for streaming data between database instances to provide additional resiliency and flexibility in moving data between database instances, including writers located in different regions. This helps maintain availability for operations like switching write traffic to a different instance.

pgactive builds on the foundation PostgreSQL logical replication features, such as bidirectional replication between tables starting in PostgreSQL 16, adding capabilities that simplify managing active-active replication scenarios. Open sourcing the pgactive extension allows for more collaboration on developing active-active capabilities of PostgreSQL, while offering features that simplify using PostgreSQL in scenarios that benefit from multiple active instances.

To learn more about pgactive and how to get started, visit the GitHub repository.