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

• Compatibility
• General Information
  • EDB Postgres Distributed 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
• Plannning
  • 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
    • Durability options (Group Commit/CAMO)
    • Mixed PGD versions
    • Other limitations
• Installation and Administration
  • Manual Installation and Administration
    • Deploying manually
  • Automated Installation and Administration with TPA
    • Deploying EDB Postgres Distributed using Trusted Postgres Architect
  • Upgrading
    • Upgrading PGD
    • Other upgrades
• 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
  • 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
  • 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
  • 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
    • 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
  • 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
• Reference
  • PGD Reference
    • User visible catalogs and views <User visible catalogs and views>
    • System functions <System functions>
    • PGD settings <PGD settings>
    • Node management <Node management>
    • Node management interfaces <Node management interfaces>
    • Routing functions <Routing functions>
    • Commit scopes <Commit scopes>
    • Replication set management <Replication set management>
    • Replication set membership <Replication set membership>
    • DDL replication filtering <DDL replication filtering>
    • Testing and tuning commands <Testing and tuning commands>
    • Global sequence management interfaces <Global sequence management interfaces>
    • Autopartition <Autopartition>
    • Stream Triggers Reference
    • Stream triggers manipulation interfaces <Stream triggers manipulation interfaces>
    • Stream triggers row functions <Stream triggers row functions>
    • Stream triggers row variables <Stream triggers row variables>
    • Internal catalogs and views <Internal catalogs and views>
    • Internal system functions <Internal system functions>