EDB Postgres Distributed (PGD)

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 commit-at-most-once , or Eager Replication.

• Introduction
  • Compatibility
  • Compatibility matrix
• EDB Postgres Distributed Release notes
  • EDB Postgres Distributed 5.3.0 release notes
    • Highlights of EDB Postgres Distributed 5.3.0
    • Compatibility
    • Enhancements
    • Bug fixes
  • EDB Postgres Distributed 5.2.0 release notes
    • Highlights of EDB Postgres Distributed 5.2.0
  • EDB Postgres Distributed 5.1.0 release notes
    • Highlights of EDB Postgres Distributed 5.1
  • EDB Postgres Distributed 5.0.1 release notes
  • EDB Postgres Distributed 5.0.0 release notes
• Known issues
• Quick Start
  • Quick start
  • Introducing PGD and TPA
  • Selecting Docker, Linux hosts, or AWS quick starts
    • Docker quick start
    • Linux host quick start
    • AWS quick start
  • Further explorations with your cluster
    • Deploying an EDB Postgres Distributed example cluster on Docker
    • Deploying an EDB Postgres Distributed example cluster on Linux hosts
    • Deploying an EDB Postgres Distributed example cluster on AWS
    • Deploying an EDB Postgres Distributed example cluster on Azure and Google cloud platforms
    • Connecting to your database
    • Exploring failover handling with PGD
    • Exploring conflict handling with PGD
    • Next Steps with PGD
• Concepts
  • Quick start
  • Introducing PGD and TPA
  • Selecting Docker, Linux hosts, or AWS quick starts
    • Docker quick start
    • Linux host quick start
    • AWS quick start
  • Further explorations with your cluster
    • PGD overview
    • Terminology
• Planning
  • Choosing your architecture
    • Standard EDB Always On architectures
    • Architecture details
    • Choosing your architecture
    • Adding flexibility to the standard architectures
  • Choosing a Postgres distribution
  • Choosing your deployment method
  • Other considerations
    • Data consistency
    • Deployment
    • Sizing considerations
    • Clocks and timezones
  • Limitations
    • Nodes
    • Multiple databases on single instances
    • CAMO
    • Group Commit
    • Eager
    • Other limitations
• Installing
  • Upgrading
    • Upgrading PGD
    • Other upgrades
  • Deploying EDB Postgres Distributed using Trusted Postgres Architect
    • Prerequisite: Install TPA
    • Configure
    • Provision
    • Deploy
    • Test
• Using
  • Application use
    • Application behavior
    • DML and DDL replication and nonreplication
    • Nodes with differences
    • General rules for applications
    • Timing considerations and synchronous replication
    • Use of table access methods (TAMs) in PGD
  • Node management
    • Node types
    • Groups and subgroups
    • Creating and joining PGD groups
    • Witness nodes
    • Logical standby nodes
    • Physical standby nodes
    • Subscriber-only nodes and groups
    • Viewing PGD topology
    • Removing nodes and groups
    • Joining a heterogeneous cluster
    • Connection DSNs and SSL (TLS)
    • Decoding worker
    • Replication slots created by PGD
    • Node restart and down node recovery
  • Postgres configuration
    • Postgres settings
    • Time-based snapshots
    • Max prepared transactions
  • DDL replication
    • DDL replication options
    • Executing DDL on PGD systems
    • DDL locking details
    • Minimizing the impact of DDL
    • Handling DDL with down nodes
    • Statement-specific DDL replication concerns
    • PGD DDL command handling matrix
  • Security and roles
    • Roles
    • Role management
    • PGD predefined roles
    • Roles and replication
    • Access Control
  • Sequences
    • PGD global sequences
    • UUIDs, KSUUIDs, and other approaches
    • See also
  • Durability
    • Overview
    • Terms and definitions
    • Comparison
    • Internal timing of operations
    • Configuration
    • Planned shutdown and restarts
    • Legacy synchronous replication using PGD
  • Consistency
    • Conflicts
    • Column-level conflict detection
    • Conflict-free replicated data types
    • Eager conflict resolution
  • Parallel Apply
    • What is Parallel Apply?
  • Replication sets
    • Using replication sets
    • Behavior of partitioned tables
    • Behavior with foreign keys
    • Replication set membership
    • Listing replication sets
    • DDL replication filtering
    • Selective Replication Example
  • Application connection management
    • Configuration
  • Backup and recovery
    • Backup
    • Restore
  • Monitoring
    • OpenTelemetry integration
    • Monitoring through SQL
  • EDB Postgres Distributed Command Line Interface
    • Installing PGD CLI
    • Using PGD CLI
    • Configuring PGD CLI
    • Discovering connection strings
    • Command reference
  • Transaction streaming
    • PGD enhancements
    • Configuration
    • Monitoring
  • Testing and tuning PGD clusters
    • Trusted Postgres Architect
    • pgd_bench
    • Notes on pgd_bench usage
  • Stream triggers
    • Trigger execution during Apply
    • Terminology of row-types
    • Conflict triggers
    • Transform triggers
    • Row contents
    • Execution order
    • Stream triggers examples
  • AutoPartition
    • Auto creation of partitions
    • Autopartition Examples
    • RANGE-partitioned tables
    • Stopping automatic creation of partitions
    • Waiting for partition creation
    • Finding a partition
    • Enabling or disabling AutoPartitioning
  • Explicit two-phase commit (2PC)
    • Use
  • Timestamp-based snapshots
• PGD Reference
  • Stream Triggers Reference
    • User visible catalogs and views
    • System functions
    • PGD settings
    • Node management
    • Node management interfaces
    • Routing functions
    • Replication set management
    • Replication set membership
    • DDL replication filtering
    • Testing and tuning commands
    • Global sequence management interfaces
    • Autopartition
    • Stream Triggers Reference
    • Internal catalogs and views
    • Internal system functions