EDB Postgres Distributed (PGD) v5

Suggest edits

EDB Postgres Distributed (PGD) provides multi-master replication and data distribution with advanced conflict management, data-loss protection, and throughput up to 5X faster than native logical replication. It enables distributed Postgres 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. You can configure additional levels of synchronicity between different nodes, groups of nodes, or all nodes by configuring Group Commit, CAMO, or Eager Replication.

Compatibility

EDB Postgres Distributed 5 is compatible with

Package	Versions
Community PostgreSQL	12-16
EDB Postgres Extended Server	12-16
EDB Postgres Advanced Server	12-16

Postgres 16 support

Postgres 16 support is only available in EDB Postgres Distributed 5.3 and later

See the compatibility matrix for previous versions

Release notes

Release notes for EDB Postgres Distributed

Known issues

Known issues in EDB Postgres Distributed 5

Concepts

Terminology

Terminology associated with EDB Postgres Distributed that you might be unfamiliar with.

PGD overview

An overview of EDB Postgres Distributed architecture and performance characteristics

Get Started

Quick start

How to select your PGD quick start deployment and what to expect from the experience.

Planning

Understand the requirements of your application and the capabilities of PGD to plan your deployment.

Deploying and Configuring

How to deploy EDB Postgres Distributed with a range of deployment options.

Using

Application use

How to develop an application that uses PGD and how PGD behaves with applications

Node management

Managing nodes and groups in a PGD cluster

Postgres configuration

Postgres configuration parameters that affect PGD nodes.

DDL replication

How DDL is replicated in PGD and when it is not

Security and roles

Security, roles and access control in EDB Postgres Distributed

Sequences

Globally distributed sequences in PGD, how they work and how to use them

Durability

Durability options, commit scopes and lag control in EDB Postgres Distributed (PGD) 5.

Consistency

PGD's options for resolving conflicts that arise when multiple nodes write to the same or related rows.

Parallel Apply

A feature of PGD that allows a PGD node to use multiple writers per subscription.

Replication sets

Grouping tables to enable more complex replication topologies

Connection management

How to use PGD Proxy to maintain consistent connections to the PGD cluster.

Backup and recovery

Backup and recovery in PGD

Monitoring

Monitoring EDB Postgres Distributed through Postgres Enterprise Manager, SQL, and OpenTelemetry

PGD CLI

Installing and using the PGD Command Line Interface (CLI) to manage your PGD cluster.

Transaction streaming

Transaction streaming in PGD

Testing and tuning

Learn how to test and tune EDB Postgres Distributed clusters.

Stream triggers

How to trigger additional data processing on a downstream/target node using stream triggers in PGD.

PGD AutoPartition

How to use autopartioning in PGD to split tables into several partitions.

Two-phase commit

Explicit two-phase commit in PGD and how to use it

Timestamp-based snapshots

Learn how to use timestamp-based snapshots in EDB Postgres Distributed.

Upgrading

Upgrading EDB Postgres Distributed and Postgres

Reference

PGD Reference

The complete reference to all functions, views and commands available in EDB Postgres Distributed.