pgEdge
activeby pgEdge, Inc. · since 2023 · also known as pgEdge Distributed Postgres, pgEdge Enterprise Postgres, Spock
Fully open-source multi-master distributed PostgreSQL built on the Spock logical replication extension.
Overview
pgEdge packages standard PostgreSQL with Spock, its multi-master logical replication extension, plus Snowflake sequences and large-object replication, to run active-active Postgres clusters across regions or edge sites. Each node is a normal Postgres server accepting writes, and Spock replicates changes asynchronously with configurable conflict resolution and delta-apply for counters. In September 2025 pgEdge relicensed all components under the PostgreSQL License, and it sells Enterprise Postgres builds, support and a managed offering. It suits globally distributed apps that can tolerate eventual consistency between nodes, not workloads needing distributed serializable transactions.
Strengths & trade-offs
Strengths
- +Active-active writes in every region using standard PostgreSQL
- +Conflict resolution and delta-apply columns for counters
- +Automatic DDL replication across nodes
- +Entirely PostgreSQL-licensed, including Spock
- +Runs on any cloud or on-prem, including air-gapped sites
Trade-offs
- −Asynchronous replication means conflicts and eventual consistency between nodes
- −No automatic sharding: every node holds all data
- −Schema and sequence design must account for multi-master
- −Smaller vendor and community than mainstream Postgres distributions
Great for
- +Multi-region active-active applications with low local latency
- +Edge deployments that must keep writing during network partitions
- +Zero-downtime major-version upgrades via logical replication
- +Data residency setups with regional write nodes
Think twice for
- −Workloads needing globally serializable transactions
- −Datasets too large to replicate fully to every node
- −Teams wanting a single-region primary-replica setup
Capabilities
Native or official first-party support · 13 of 25 tracked
Scale & consistency
- Comfortable data size
- Medium · ≤ 10 TB
- Horizontal scaling
- Manual
- Multi-region
- Active active
- Transactions
- Full ACID
- Consistency
- Eventual, Strong
- Schema
- Strict
- Architecture
- Multi primary, Distributed, Client server
- Query languages
- SQL, PL/pgSQL
Full copies on each node with async multi-master replication; no automatic sharding.
Deployment
available on · AWS · Azure · Google Cloud
Ecosystem
Alternatives to pgEdge
The extensible, standards-first open-source relational database.
pgedge vs postgresql →Postgres-wire distributed SQL built to survive node, zone and region failures with serializable transactions.
pgedge vs cockroachdb →Apache-licensed distributed SQL that reuses the PostgreSQL query layer on a Raft-replicated storage engine.
pgedge vs yugabytedb →EnterpriseDB's PostgreSQL with deep Oracle compatibility: PL/SQL packages, DBMS_* and TDE.
pgedge vs edb-postgres-advanced-server →Postgres extension that shards tables across nodes for multi-tenant SaaS and real-time analytics.
pgedge vs citus →Google's globally consistent, horizontally scaling SQL service with graph, vector and full-text built in.
pgedge vs google-cloud-spanner →pgEdge FAQ
What is pgEdge?
pgEdge is a relational database by pgEdge, Inc., first released in 2023. pgEdge packages standard PostgreSQL with Spock, its multi-master logical replication extension, plus Snowflake sequences and large-object replication, to run active-active Postgres clusters across regions or edge sites. Each node is a normal Postgres server accepting writes, and Spock replicates changes asynchronously with configurable conflict resolution and delta-apply for counters. In September 2025 pgEdge relicensed all components under the PostgreSQL License, and it sells Enterprise Postgres builds, support and a managed offering. It suits globally distributed apps that can tolerate eventual consistency between nodes, not workloads needing distributed serializable transactions.
Is pgEdge open source?
Yes. pgEdge is open source. License: PostgreSQL License.
Does pgEdge support ACID transactions?
Yes. pgEdge supports full ACID transactions, with eventual, strong consistency.
Does pgEdge scale horizontally?
pgEdge has no built-in sharding; scaling out means partitioning data in your application. It is comfortable at medium scale (≤ 10 TB). It supports active-active multi-region writes.
How can I run pgEdge?
You can self-host it and use the vendor's managed cloud. Managed offerings include pgEdge Cloud. It is available on AWS, Azure and Google Cloud.
What is pgEdge best for?
pgEdge is a strong fit for multi-region active-active applications with low local latency, edge deployments that must keep writing during network partitions and zero-downtime major-version upgrades via logical replication. Think twice for workloads needing globally serializable transactions.
What are the best alternatives to pgEdge?
Common alternatives to pgEdge include PostgreSQL, CockroachDB, YugabyteDB, EDB Postgres Advanced Server and Citus. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
How popular is pgEdge?
pgEdge ranks #302 of 844 databases on the WhichDB Score (10.1/100), and #96 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.