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
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
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