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.

• Introduction
  • The foundation: 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.5.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Bug Fixes
    • Deprecations
  • EDB Postgres Distributed 6.4.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Bug Fixes
  • EDB Postgres Distributed 6.3.1 release notes
    • Bug Fixes
  • 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.2 release notes
    • Bug Fixes
  • EDB Postgres Distributed 6.1.1 release notes
    • Bug Fixes
  • EDB Postgres Distributed 6.1.0 release notes
    • Highlights
    • Features
    • Enhancements
    • Changes
    • Bug Fixes
  • EDB Postgres Distributed 6.0.2 release notes
    • Bug Fixes
  • EDB Postgres Distributed 6.0.1 release notes
    • Highlights
    • Features
    • Enhancements
    • Changes
    • Bug Fixes
• Quickstart guide
  • Creating your first cluster
    • Prerequisites
    • Install the PGD Docker Quickstart kit
    • Accessing the PGD Cluster
    • Next Steps
  • Working with SQL and the PGD cluster
    • Connecting within the PGD Cluster
    • Working with SQL
    • Replicating data across the cluster
    • Next Steps
  • Loading data into your PGD Cluster
    • Online CSV Importing
    • Next Steps
  • Using PGD CLI
    • Viewing cluster status
    • Viewing groups and group status
    • Viewing nodes and node status
    • Setting node options
• Overview
  • 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
    • Quorum Commit
    • 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
  • Known issues and limitations
    • Known issues
    • Limitations
  • PGD compatibility
    • PGD compatibility with Postgres versions
    • PGD compatibility with operating systems and architectures
  • Product lifecycle and release roadmap
    • Currently supported versions
    • What’s coming
• Planning your PGD deployment
  • Deployment patterns
    • Choosing a pattern
    • Architectural elements
  • Choosing a Postgres distribution
  • Choosing your deployment method
  • Comparing replication solutions
    • Deployment
    • Performance
    • Durability
    • Consistency
    • Data distribution
    • Maintenance
    • Connection Management
    • DDL support
    • Postgres compatibility
    • Management
    • Licensing
  • 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
• Installing and configuring EDB Postgres Distributed
  • Manually
    • Prerequisites
    • Configuring PGD repositories
    • Installing the database and pgd
    • Configuring the cluster
    • Checking the cluster
    • Connecting to your PGD cluster
  • 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
    • Upgrading PGD clusters manually
    • Supported PGD upgrade paths
    • Compatibility changes
    • Upgrading application schemas
    • In-place Postgres or Postgres and PGD major version upgrades
    • Performing a Postgres major version rolling upgrade on a PGD cluster
• Maintaining your PGD cluster
  • 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
  • Monitoring
    • Monitoring through SQL
    • Using the PGD Monitor
  • Migrating to Postgres Distributed (PGD)
    • Migrating from Postgres Physical Streaming Replication (PSR) to PGD
• Guidance for DBAs
  • Ensuring security
    • Setting up access controls
    • Encrypting columns in PGD
  • Configuring connection pooling
    • Prerequisites
    • Enabling connection pooling
    • Monitoring the pool
    • Migrating from pgBouncer
  • Managing geo-replication
    • When to use geo-replication
    • Deployment workflow
  • Using tiered storage
    • Understanding table types
    • Tiered storage strategies
    • Metadata management
  • Recovering from failures
    • Handling replication apply errors
    • Recovering a failed node
• Guidance for Developers
  • Designing applications for PGD
    • Assessing an existing application for PGD
    • Preparing your application for PGD
  • Achieving durability with commit scopes
    • Using predefined scopes
    • Fine-tuning with custom scopes
  • Using connection pooling in your application
    • Understanding the active pool mode
    • Adapting your application for transaction mode
  • Developing applications for geo-replication
    • When geo-replication affects your application
    • Make your application geo-replication ready
• Deep Dive
  • 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
    • Node restart and down node recovery
    • Automatic synchronization
    • Node UUIDs
    • Replication slots created by PGD
  • Connection Manager
    • Connection Manager overview
    • Connection Manager Authentication
    • Connection pooling
    • Load Balancing with Connection Manager
    • Configuring Connection Manager
    • Monitoring the Connection Manager
  • Postgres configuration
    • Postgres settings
    • Max prepared transactions
    • Considerations for global configuration
  • 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
  • Working with
    • Introducing
    • Commit scope kinds
    • Working with commit scopes
  • Conflict Management
    • Conflicts
    • Column-level conflict detection
    • Conflict-free replicated data types
  • Advanced functionality
    • DDL replication
    • Application use
    • Decoding worker
    • CDC Failover support
    • Parallel Apply
    • Replication sets
    • Security and roles
    • Sequences
    • Replicated large objects
    • Stream triggers
    • Transaction streaming
    • Explicit two-phase commit (2PC)
• Referecne
  • PGD Reference
    • Tables, views and functions reference
    • EDB Postgres Distributed Command Line Interface (PGD CLI)