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 , Upgrading a CAMO-enabled cluster , or Eager All-Node Replication Replication.

• General Information
  • Compatibility)
  • EDB Postgres Distributed release notes
    • EDB Postgres Distributed 5.5.1 release notes
    • EDB Postgres Distributed 5.5.0 release notes
    • EDB Postgres Distributed 5.4.1 release notes
    • EDB Postgres Distributed 5.4.0 release notes
    • EDB Postgres Distributed 5.3.0 release notes
    • EDB Postgres Distributed 5.2.0 release notes
    • EDB Postgres Distributed 5.1.0 release notes
    • EDB Postgres Distributed 5.0.1 release notes
    • EDB Postgres Distributed 5.0.0 release notes
  • Known issues
• Concepts
  • Terminology
    • Asynchronous replication
    • Commit scopes
    • CAMO or commit-at-most-once
    • Conflicts
    • Consensus
    • Cluster
    • DDL (data definition language)
    • DML (data manipulation language)
    • Eager
    • Eventual consistency
    • Failover
    • Group commit
    • Immediate consistency
    • Logical replication
    • 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
  • PGD overview
    • Basic architecture
    • Architectural options and performance
• Get Started
  • Introducing PGD quick starts
    • Quick start
    • Introducing PGD and TPA
    • Selecting Docker, Linux hosts, or AWS quick starts
    • Further explorations with your cluster
  • Planning your PGD deployment
    • Choosing your architecture
    • Choosing a Postgres distribution
    • Choosing your deployment method
    • Other considerations
    • Limitations
  • Deploying and configuring EDB Postgres Distributed
    • Manual deployment and configuration of PGD
    • Deployment and management with TPA
    • Deploying and configuring PGD on Kubernetes
    • Deploying and configuring PGD on EDB BigAnimal
• 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
    • Feature compatibility
  • 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
  • Sequences
    • PGD global sequences
    • UUIDs, KSUUIDs, and other approaches
    • See also
• Administration
  • Node management
    • Node types
    • Groups and subgroups
    • Creating and joining PGD groups
    • Witness nodes
    • Logical 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
    • Maintenance commands through proxies
  • Postgres configuration
    • Postgres settings
    • Time-based snapshots
    • Max prepared transactions
  • PGD Proxy
    • EDB Postgres Distributed Proxy overview
    • Installing PGD Proxy
    • PGD Proxy configuration
    • Administering PGD Proxy
    • Monitoring PGD Proxy
    • Read-only routing with PGD Proxy
    • Proxies, Raft, and Raft subgroups
  • Backup and recovery
    • Backup
    • Restore
  • Security and roles
    • Roles
    • Role management
    • PGD predefined roles
    • Roles and replication
    • Access control
  • Monitoring
    • OpenTelemetry integration
    • Monitoring through SQL
  • Testing and tuning PGD clusters
    • Trusted Postgres Architect
    • pgd_bench
    • Notes on pgd_bench usage
  • Upgrading
    • Upgrading PGD
    • Upgrading Postgres
    • Other upgrades
• Tools
  • EDB Postgres Distributed Command Line Interface (PGD CLI)
    • Installing PGD CLI
    • Using PGD CLI
    • Configuring PGD CLI
    • Discovering connection strings
    • Command reference
• PGD Features
  • Durability
    • Introducing
    • Commit scope kinds
    • Working with commit scopes
  • 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
  • Stream triggers
    • Trigger execution during Apply
    • Terminology of row-types
    • Conflict triggers
    • Transform triggers
    • Row contents
    • Execution order
    • Stream triggers examples
  • PGD 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
  • Transaction streaming
    • PGD enhancements
    • Configuration
    • Monitoring
  • Timestamp-based snapshots
• PGD reference
  • User visible catalogs and views
  • System functions
    • Version information functions
    • System information functions
    • System and progress information parameters
    • Consensus function
    • Utility functions
    • Global advisory locks
    • Monitoring functions
    • CAMO functions
    • Commit Scope functions
  • PGD settings
    • Exploring conflict handling with PGD
    • Global sequence parameters
    • DDL handling
    • Global locking
    • Node management
    • Generic replication
    • State-based and operation-based CRDTs
    • Commit scopes
    • Commit At Most Once
    • Transaction streaming
    • Lag Control
    • Timestamp-based snapshots
    • Monitoring and logging
    • Decoding worker
    • Connectivity settings
    • Internal settings - Raft timeouts bdr.raft_global_election_timeout
    • Internal settings - Other Raft values
    • Internal settings - Other values
  • Node management
  • Node management interfaces
  • Routing functions
  • Commit scopes
  • Replication set management
  • Replication set membership
  • DDL replication filtering
  • Testing and tuning commands
  • Global sequence management interfaces
    • Sequence functions
    • KSUUID v2 Functions
    • KSUUID v1 functions
  • PGD AutoPartition
  • Stream triggers reference
  • Stream triggers manipulation interfaces
  • Stream triggers row functions
  • Stream triggers row variables
  • Internal catalogs and views
  • Internal system functions
    • General internal functions
    • Task Manager Functions
• PGD Compatibility by PostgreSQL Version