EDB Postgres Distributed (PGD) v6.2.0
Welcome to the PGD 6.2.0 documentation. PGD 6.2.0 is available in two editions: Essential and Expanded.
Why PGD?
Modern data architectures require an extensible approach to data management, whether the requirement is for high availability, disaster recovery or multi-region data distribution. PGD is designed to meet these needs, and in PGD 6 we have made it easier to get started with PGD, while also providing a pathway to using advanced features as your use case becomes more complex.
What does PGD enable?
PGD enables you to build a distributed database architecture that can span multiple regions, data centers, or cloud providers. It provides multi-master replication and data distribution. Postgres databases can be deployed into data groups within the cluster and data within each node can be distributed across multiple nodes.
What are the differences between PGD Essential and PGD Expanded?
PGD Expanded is the full-featured version of PGD. It includes all the features of PGD Essential, as well as additional features such as advanced conflict management, data distribution, and support for large-scale deployments. PGD Expanded is designed for users who need the most advanced features and capabilities of PGD.
PGD Essential is a simplified version of PGD Expanded. It is designed for users who want to get started with PGD quickly and easily, without the need for advanced features or complex configurations. PGD Essential includes the core features of PGD but enables them in a way that makes replication and availability simple. It therefore does not include some of the more advanced features available in PGD Expanded.
PGD Essential limits the number of data nodes in a cluster to four and the number of groups to two. It also limits the number of nodes in a group to four. PGD Expanded does not have these limitations.
Learn more about PGD in Get Started with PGD.
Getting Started
Get started
Get started with EDB Postgres Distributed, installing and configuring the software, and creating your first cluster.
How To...
Essential How-To
Essential how-to guides for deploying and managing your PGD cluster.
Expanded How-to
How to use PGD Expanded's advanced features and capabilities.
In Depth
PGD concepts explained
The concepts behind EDB Postgres Distributed (PGD) 6.0 and how they work in practice.
PGD overview
An overview of EDB Postgres Distributed architecture and performance characteristics
Configuration and Management
Node types
The different types of nodes that can be configured and grouped in a PGD cluster
Node management
Managing nodes and groups in a PGD cluster
Connection Manager
How to use and configure integrated Connection Manager
Postgres configuration
Postgres configuration parameters that affect PGD nodes.
Backup and recovery
Backup and recovery
Monitoring
Monitoring EDB Postgres Distributed through Postgres Enterprise Manager, SQL, and OpenTelemetry
AutoPartition
How to use autopartitioning in PGD to split tables into several partitions.
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.
Testing and tuning
Learn how to test and tune EDB Postgres Distributed clusters.
Upgrading
Upgrading EDB Postgres Distributed and Postgres
Advanced functionality
DDL replication
How DDL is replicated in PGD and when it isn't
Decoding worker
Decoding worker in PGD reduces CPU overhead and increases replication throughput by enabling a optimized decoding worker process.
CDC Failover support
CDC Failover support (PGD Logical Slot Failover) with EDB Postgres Advanced Server and EDB Postgres Extended Server
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.
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.
Stream triggers
How to trigger additional data processing on a downstream/target node using stream triggers in PGD.
Transaction streaming
Transaction streaming in PGD.
Two-phase commit
Explicit two-phase commit in PGD and how to use it.
Guidance for developers
Application use
How to develop an application that uses PGD and how PGD behaves with applications
Reference
PGD Reference
Reference documentation for EDB Postgres Distributed (PGD) 6.0.
Terminology
Terminology associated with EDB Postgres Distributed that you might be unfamiliar with.
Appendix
Compatibility
Compatibility of EDB Postgres Distributed with different versions of PostgreSQL
Release notes
Release notes for EDB Postgres Distributed 6 and later
Known issues and limitations
Known issues and limitations in EDB Postgres Distributed 6.2.0