pgactive

We have hosted the application pgactive in order to run this application in our online workstations with Wine or directly.

Quick description about 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.

Features:

• Enables writable multi-node (active-active) replication for PostgreSQL clusters
• Conflict detection and resolution mechanisms (e.g., conflict history tables, last-write-wins)
• Commands and administration tools to join/detach nodes and manage replication sets
• Built on PostgreSQL logical replication, supporting multiple versions and upgrades
• Monitoring of replication lag, node connectivity, and replication health
• Apache 2.0 licensed extension, suitable for integration with RDS/PostgreSQL ecosystems

Programming Language: C.
Categories: