aws/pgactive

Health v2 · maintenance only

Adoption not part of the score

1108 stars · 38 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pgactive is a PostgreSQL extension written in C that enables active-active replication, allowing multiple database instances in a cluster to accept writes and replicate changes to each other asynchronously. It builds on PostgreSQL's logical replication to add conflict detection and resolution needed for multi-writer topologies.

Use cases

• run a multi-region high availability PostgreSQL cluster with writable nodes
• reduce write latency by letting applications write to the nearest database instance
• perform blue/green application updates with both databases writable
• migrate data between systems that must both accept writes
• replicate changes between production and test databases bidirectionally

When to choose

• you need multiple writable PostgreSQL nodes in an asynchronous active-active topology
• you want conflict detection and resolution on top of native PostgreSQL logical replication
• you are building multi-region HA or low-latency write deployments on PostgreSQL

When to avoid

• you need a single source of truth or synchronous replication guarantees
• your application cannot handle replication lag or conflicting writes
• you rely on features incompatible with multi-writer setups like incremental integer sequences
• you use a database other than PostgreSQL

Facets

library · maturity active

database message-queue databases microservices backend self-hosted cloud postgresql-extension active-active logical-replication multi-region high-availability conflict-resolution replication linux

Member repositories

For agents

markdown · JSON · MCP: product_card(name="aws/pgactive")