pgEdge and Spock extension Multi-Master Logical Replication

Postgres Conference 2023 Silicon Valley: 20 min. Presentation


Full support of multi-active logical replication in pgLogical has gone unsupported for many years. In this talk we will discuss the work we have done to bring back multi-active replication in a new derivative of pgLogical we call Spock. Spock is available as an open source PostgreSQL extension under a community open source license.

High performance web applications increasingly need presentation, compute and data hosted at or near the network edge. To date being able to place read/write copies of databases at the network edge has been problematic. At a minimum placing data and databases in a handful of cloud regions closer to end users can deliver a superior experience for the end user. We describe how Spock makes this possible using Delta Conflict Avoidance.

Additionally we will cover how we implement geographic data residency in support of cross-region. Recent regulatory developments in the EU, India and elsewhere increasingly require guarantees that data generated by citizens remains resident in-country or in-region. We will show how we have extended the replication algorithms to ensure that sensitive data such as PII does not cross national or regional borders while globally replicating data that is needed across the world.

Dive deeper into pgEdge


Enhancing pgLogical with Multi-Master (Active-Active) Features


Whitepaper: 21 Ways Multi-Master Distributed Postgres Improves Costs and Customer Loyalty


Unlocking PostgreSQL 16 New Features


Integrating pgEdge Distributed PostgreSQL with Cloudflare Workers for low latency database access

Get started today.

Experience the magic of pgEdge Distributed PostgreSQL now.

pgedge logo RGB lockup

pgEdge provides distributed PostgreSQL optimized for the network edge to reduce data latency and achieve ultra high availability. Only pgEdge combines multi-master (active-active), multi-region and multi-cloud in a fully managed cloud service that is 100% standard Postgres and 100% open (source available).

2023 ©pgEdge, Inc.

2023 ©pgEdge, Inc.