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.

Read about why PostgreSQL is better when it’s distributed with EDB Postgres Distributed in Distributed PostgreSQL:The Key to Always On Database Availability

PGD Free Trial

Contact Sales

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 Synchronous Commit , Group Commit (optionally with Eager conflict resolution ), or Commit At Most Once .

---

• Genral Information
  • Compatibility
  • EDB Postgres Distributed 5 release notes
    • EDB Postgres Distributed 5.7.0 release notes
    • EDB Postgres Distributed 5.6.1 release notes
    • EDB Postgres Distributed 5.6.0 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
    • PGD overview - architecture and performance
    • Architecture overview
    • PGD compared
• 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 Postgres AI Cloud Service
• 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
    • Using extensions with PGD
  • 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
    • Groups and subgroups
    • Creating and joining PGD groups
    • Viewing PGD topology
    • Removing nodes and groups
    • Joining a heterogeneous cluster
    • Connection DSNs and SSL (TLS)
    • Replication slots created by PGD
    • Node restart and down node recovery
    • Maintenance commands through proxies
    • Creating PGD nodes
  • 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 or Postgres and PGD major versions
    • 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
  • Node types and capabilities
    • An overview of PGD Node types
    • Witness nodes
    • Logical standby nodes
    • Subscriber-only nodes and groups
  • Commit Scopes
    • Introducing
    • Commit scope kinds
    • Working with commit scopes
  • Conflict Management
    • Conflicts
    • Column-level conflict detection
    • Conflict-free replicated data types
  • 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
    • Restrictions on EDB Postgres Advanced Server-native automatic partitioning
  • Explicit two-phase commit (2PC)
    • Use
  • Decoding worker
    • Enabling
    • Disabling
  • Transaction streaming
    • PGD enhancements
    • Configuration
    • Monitoring
  • Timestamp-based snapshots
  • CDC Failover support
    • Background
    • CDC Failover support
    • Enabling CDC Failover support
    • CDC Failover support with Postgres 17+
    • Limitations
• Reference
  • PGD reference
    • User visible catalogs and views
    • System functions
    • PGD settings
    • Node management
    • Node management interfaces
    • Routing functions
    • Monitoring commit scopes
    • Monitoring conflicts
    • Column-level conflict functions
    • Replication set management
    • Replication set membership
    • DDL replication filtering
    • Testing and tuning commands
    • Global sequence management interfaces
    • PGD AutoPartition
    • 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
    • Monitoring conflicts
  • Data migration to EDB Postgres Distributed
    • EDB*Loader and PGD
• PGD compatibility
  • PGD compatibility with PostgreSQL versions
  • PGD compatibility with operating systems and architectures
    • Linux x86_64 (amd64)
    • Linux ppc64le
    • Linux arm64/aarch64