pgactive

pgactive is an open-source extension for PostgreSQL that enables active-active replication across multiple database instances—meaning each node can accept writes and replicate changes to other nodes. Traditionally PostgreSQL supports active-standby setups (single writable master), but pgactive opens up use cases such as multi-region high-availability clusters, low-latency writes from distributed apps, and blue/green migrations where both sides are writable. It builds on PostgreSQL’s logical replication framework and offers mechanisms for conflict detection, resolution (e.g., last-write-wins), monitoring of lag and writes across nodes. Because active-active replication introduces new complexity (conflicts, schema changes, write amplification), pgactive provides tools for managing replication sets, conflict logging tables, and administrative commands to detach nodes or remove the extension.