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

Project Samples

Project Activity

See All Activity >

Categories

Database

License

Apache License V2.0

Follow pgactive

pgactive Web Site

Other Useful Business Software
Paessler: Easy to Use With Enterprise Power. Free Trial Icon
Paessler: Easy to Use With Enterprise Power. Free Trial

A low-code dashboard makes monitoring intuitive for any admin, while scripting and custom sensors give experts full control.

You shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
Get Free Download
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pgactive!

Additional Project Details

Programming Language

C

Related Categories

C Database Software

Registered

2025-10-20