EDB Postgres Distributed (PGD) v5.6

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.

Read about why PostgreSQL is better when it’s distributed with EDB Postgres Distributed in Distributed PostgreSQL:The Key to Always On Database Availability

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 Synchronous Commit, Group Commit (optionally with Eager Conflict Resolution), or CAMO.

Compatibility

EDB Postgres Distributed 5 is compatible with the package versions shown in the table.

PackageVersions
Community PostgreSQL12-16
EDB Postgres Extended Server12-16
EDB Postgres Advanced Server12-16
Postgres 16 support

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

For feature compatibility with compatible servers, see Choosing a Postgres distribution.

Release notes

Release notes for EDB Postgres Distributed 5.6+

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

DDL replication

How DDL is replicated in PGD and when it isn't

Sequences

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

Administration

Node management

Managing nodes and groups in a PGD cluster

Postgres configuration

Postgres configuration parameters that affect PGD nodes.

PGD Proxy

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

Backup and recovery

Backup and recovery in PGD

Security and roles

Security, roles, and access control in EDB Postgres Distributed.

Monitoring

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

Testing and tuning

Learn how to test and tune EDB Postgres Distributed clusters.

Upgrading

Upgrading EDB Postgres Distributed and Postgres

Data migration

Data migration to EDB Postgres Distribution

Tools

PGD CLI

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

PGD Features

Node types

The different types of nodes that can be configured and grouped in a PGD cluster

Commit Scopes

Durability options, commit scopes, and lag control in PGD.

Conflict Management

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.

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.

Transaction streaming

Transaction streaming in PGD.

Timestamp-based snapshots

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

Reference

PGD reference

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

Compatibility

Compatibility of EDB Postgres Distributed with different versions of PostgreSQL