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.
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 PostgreSQL, EDB Postgres Extended, and EDB Postgres Advanced versions 12-17. See the compatibility section for more details, including compatibility with different operating systems and architectures. For feature compatibility with compatible servers, see Choosing a Postgres distribution.
Release notes
Release notes for EDB Postgres Distributed 5.6 and later
Known issues
Known issues in EDB Postgres Distributed 5
Compatibility
Compatibility of EDB Postgres Distributed with different versions of PostgreSQL
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 autopartitioning in PGD to split tables into several partitions.
Two-phase commit
Explicit two-phase commit in PGD and how to use it.
Decoding worker
Decoding worker in PGD reduces CPU overhead and increases replication throughput by enabling a optimized decoding worker process.
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.