EDB Postgres Distributed (PGD) v5
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 Group Commit, CAMO, or Eager Replication.
Compatibility
EDB Postgres Distributed 5 is compatible with the package versions shown in the table.
| 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 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
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
Durability
Durability options, commit scopes, and lag control in PGD.
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.
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