EDB Postgres Distributed (PGD)

EDB Postgres Distributed (PGD) is an integrated software stack that transforms standard PostgreSQL into a distributed, always-on database platform. Designed for the modern enterprise where downtime is no longer an option, PGD provides a robust framework for global data distribution, high availability, and simplified consistency management.

• PostgreSQL transformed
  • Continuous business continuity (Active-Active)
  • Simplified consistency via commit scopes
  • Granular data locality & sovereignty
  • Automated conflict management
  • Global read scaling with subscriber only nodes
  • Managed data lifecycle: AutoPartition and Tiered tables
  • Seamless lifecycle management
• EDB Postgres Distributed 6 release notes
  • EDB Postgres Distributed 6.3.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Changes
    • Bug Fixes
  • EDB Postgres Distributed 6.2.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Bug Fixes
  • EDB Postgres Distributed 6.1.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Changes
    • Bug Fixes
  • EDB Postgres Distributed 6.1.1 release notes
    • Bug Fixes
  • EDB Postgres Distributed 6.1.2 release notes
    • Bug Fixes
  • EDB Postgres Distributed 6.0.1 release notes
    • Highlights
    • Features
    • Enhancements
    • Changes
    • Bug Fixes
  • EDB Postgres Distributed 6.0.2 release notes
    • Bug Fixes
• Overview
  • Known issues and limitations
    • Known issues
    • Limitations
    • CAMO
  • PGD compatibility
    • PGD compatibility with PostgreSQL versions
    • PGD compatibility with operating systems and architectures
  • Postgres Distributed terminology
    • Asynchronous replication
    • Commit scopes
    • CAMO or commit-at-most-once
    • Conflicts
    • Connection Manager
    • Consensus
    • Cluster
    • DDL (data definition language)
    • DML (data manipulation language)
    • Durability
    • Eager
    • Eventual consistency
    • Failover
    • Group commit
    • Immediate consistency
    • Lag Control
    • Logical replication
    • Logical standby node
    • Node
    • Node groups
    • PGD cluster
    • PGD node
    • Physical replication
    • Postgres cluster
    • Quorum
    • Replicated available fault tolerance (Raft)
    • Read scalability
    • Subscription
    • Switchover
    • Synchronous replication
    • Subscriber-only nodes
    • Two-phase commit (2PC)
    • Vertical scaling or scale up
    • Witness nodes
    • Write leader
    • Writer
  • Quickstart guide
    • Creating your first cluster
    • Working with SQL and the PGD cluster
    • Loading data into your PGD Cluster
    • Using PGD CLI
• Planning your PGD deployment
  • Architecture
    • High-level architecture
    • Architectural elements
    • Architectural flexibility
    • Architecture types
  • Choosing a Postgres distribution
  • Choosing your deployment method
  • Comparing replication solutions
  • Choosing between Physical Streaming Replication (PSR) and EDB Postgres Distributed (PGD)
    • PSR with EFM or Patroni
    • EDB Postgres Distributed (PGD)
  • Other considerations
    • Sizing
    • Time and PGD
• Managing lifecycle operations
  • Deploying and configuring EDB Postgres Distributed
    • Manually
    • Deploying and configuring PGD using TPA
    • Deploying and configuring PGD on Kubernetes
    • Deploying and configuring PGD on Hybrid Manager
  • Upgrading
    • Upgrading PGD
    • Upgrading Postgres or Postgres and PGD major versions
    • Other upgrades
  • Testing and tuning PGD clusters
    • pgd_bench
    • Notes on pgd_bench usage
  • Backup and recovery
    • Logical backup and restore
    • Physical backup and restore
    • Eventual consistency
    • Monitoring
  • Migrating to Postgres Distributed (PGD)
    • Migrating from Postgres Physical Streaming Replication (PSR) to PGD
• Configure and Management
  • Node types and capabilities
    • An overview of PGD Node types
    • Witness nodes
    • Logical standby nodes
    • Subscriber-only nodes and groups
  • Node management
    • Creating PGD nodes
    • Groups and subgroups
    • Creating and joining PGD groups
    • Viewing PGD topology
    • Removing nodes and groups
    • Connection DSNs and SSL (TLS)
    • Node restart and down node recovery
    • Automatic synchronization
    • Node UUIDs
    • Replication slots created by PGD
  • Connection Manager
    • Connection Manager overview
    • Connection Manager Authentication
    • Configuring Connection Manager
    • Load Balancing with Connection Manager
    • Monitoring the Connection Manager
  • Postgres configuration
    • Postgres settings
    • Max prepared transactions
    • Considerations for global configuration
  • Monitoring
    • Monitoring through SQL
  • AutoPartition in PGD
    • 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
    • Dropping or detaching a partition
  • Commit Scopes
    • Introducing
    • Commit scope kinds
    • Working with commit scopes
  • Conflict Management
    • Conflicts
    • Column-level conflict detection
    • Conflict-free replicated data types
• Advanced Functionality
  • CDC Failover support
    • Background
    • CDC Failover support
    • Enabling CDC Failover support
    • CDC Failover support with Postgres 17+
    • Obtaining Initial Consistent Snapshot
    • Failing Over to Newly Joined Nodes
    • Tracking Per-Origin Progress
    • Limitations
  • DDL replication
    • DDL overview
    • DDL replication options
    • DDL locking details
    • Managing DDL with PGD replication
    • DDL command handling matrix
    • DDL and role manipulation statements
    • Workarounds for DDL restrictions
    • PGD functions that behave like DDL
  • Decoding worker
    • Enabling
    • Disabling
  • 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
  • Security and roles
    • Roles
    • Role management
    • PGD predefined roles
    • Roles and replication
    • Access control
  • Sequences
    • Automatic sequence conversion
    • UUIDs, KSUUIDs, and other approaches
    • KSUUID v2 functions
    • See also
  • Stream triggers
    • Trigger execution during apply
    • Terminology of row-types
    • Conflict triggers
    • Transform triggers
    • Row contents
    • Execution order
    • Stream triggers examples
  • Transaction streaming
    • PGD enhancements
    • Configuration
    • Monitoring
  • Explicit two-phase commit (2PC)
    • Use
• Guidance for Developers
  • Application use
    • Application behavior
    • DML and DDL replication and nonreplication
    • Nodes with differences
    • General rules for applications
    • Timing considerations and synchronous replication
    • Using extensions with PGD
    • Use of table access methods (TAMs) in PGD
    • Feature compatibility
• PGD Reference
  • Tables, views and functions reference
    • User visible catalogs and views
    • System functions
    • PGD settings
    • Node management
    • Node management interfaces
    • Routing functions
    • Migration to commit scopes
    • bdr_read_all_conflicts
    • Column-level conflict functions
    • Replication set management
    • Replication set membership
    • DDL replication filtering
    • Testing and tuning commands
    • Sequences
    • AutoPartition in PGD
    • Stream triggers reference
    • Stream triggers manipulation interfaces
    • Stream triggers row functions
    • Stream triggers row variables
    • Internal catalogs and views
    • Internal system functions
    • Column-level conflict functions
    • Column-level conflict functions
    • bdr_read_all_conflicts
  • EDB Postgres Distributed Command Line Interface (PGD CLI)
    • Installing PGD CLI
    • Using PGD CLI
    • Configuring PGD CLI
    • Discovering connection strings
    • Command reference