EDB Postgres Distributed (PGD) v4

EDB Postgres Distributed provides multi-master replication and data distribution with advanced conflict management, data-loss protection, and throughput up to 5X faster than native logical replication, and enables distributed PostgreSQL clusters with high availability up to five 9s.

By default EDB Postgres Distributed uses asynchronous replication, applying changes on the peer nodes only after the local commit. Additional levels of synchronicity can be configured between different nodes, groups of nodes or all nodes by configuring Group Commit, CAMO, or Eager replication.

Compatibility matrix

EDB Postgres
Distributed
BDR
Extension
pgLogical3
Extension
HARPCommmunity
PostgreSQL
EDB Postgres
Extended Server
EDB Postgres
Advanced Server
PGD
CLI
44n/a212, 13, 1412, 13, 1412, 13, 141
3.73.73.7211, 12, 1311r2, 12, 1311, 12, 13n/a
3.63.63.6210, 1111r1n/an/a
  • PGD CLI 1 is supported with BDR 4.1 and later.
  • BDR DCS in HARP 2 is supported with BDR 3.7.15 and later and 4.0.1 and later.

Concepts

Components

HARP

High Availability Routing for Postgres (HARP) is a cluster-management tool for EDB Postgres Distributed clusters.

Planning

Installing

Using

Command line interface

The PGD Command Line Interface (CLI) is a tool to manage your EDB Postgres Distributed cluster