Introduction to pgEdge

Introduction to pgEdge

pgEdge supports a true multi-active(multi-master) distributed database system that supports secure read and write operations on any publisher or subscriber node of a replication scenario.

In a distributed PostgreSQL system, a replicated cluster can span multiple cloud regions or data centers. This is advantageous if your international regulations require data generated in a certain country or region stay in that country of origin. With pgEdge, you control which tables are globally replicated, and which stay local. Geo-sharding allows you to break out tables by location field; global data is then shared globally, while local data stays local.

pgEdge Cloud

pgEdge Cloud is fully-distributed PostgreSQL, deployable across multiple cloud regions or data centers.

pgEdge Cloud provides:

  • cloud-agnostic architecture
  • ultra high-availability
  • disaster recovery capabilities
  • data residency
  • compliance adherence
  • business continuity

These benefits collectively help mitigate risk by removing dependency on a single cloud provider and enhancing overall system resilience and flexibility.

pgEdge Platform

pgEdge Platform is the most complete and advanced distribution of open-source PostgreSQL, with extended support for multi-active (multi-master) PostgreSQL databases. pgEdge Platform includes:

  • PostgreSQL (versions 15 and 16)
  • the Spock multi-active logical replication extension
  • NodeCtl - the pgEdge node controller
  • PostgREST web API extension
  • Popular PostgreSQL extensions, including pgVector, pgCAT, pgBackRest, PostGIS, plprofiler, and foreign data wrappers

Spock

Spock is a PostgreSQL extension that provides multi-master (multi-active) replication for PostgreSQL 15 and 16. One provider node may feed multiple subscriber nodes without incurring additional disk write overhead. A subscriber can merge changes from multiple origins and detect conflict between changes with automatic and configurable conflict resolution.

Spock supports:

  • Asynchronous multi-active replication with conflict resolution
  • Upgrades between major versions
  • Full database replication
  • Selective replication of sets of tables using replication sets
  • Selective replication of table rows at either publisher or subscriber side (row_filter)
  • Selective replication of partitioned tables
  • Selective replication of table columns at publisher side
  • Data gather/merge from multiple upstream servers

See The Spock Extension (opens in a new tab) for more information about the commands you can use to manage Spock.

pgEdge Cloud