Skip to main content
Ctrl+K
EDB Postgres Distributed - PGD 5.6.1 documentation - Home
  • General Information
    • ompatibility
    • EDB Postgres Distributed 5.6+ release notes
      • EDB Postgres Distributed 5.6.1 release notes
      • EDB Postgres Distributed 5.6.0 release notes
    • Known issues
  • Concepts
    • Terminology
    • PGD overview
  • Get Started
    • Introducing PGD quick starts
      • Deploying an EDB Postgres Distributed example cluster on Docker
      • Deploying an EDB Postgres Distributed example cluster on Linux hosts
      • Deploying an EDB Postgres Distributed example cluster on AWS
      • Deploying an EDB Postgres Distributed example cluster on Azure and Google cloud platforms
      • Connecting to your database
      • Exploring replication with PGD
      • Exploring failover handling with PGD
      • Exploring conflict handling with PGD
      • Next steps with PGD
    • 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
        • Deploying PGD manually
      • Deployment and management with TPA
        • Deploying PGD using 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
      • 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
  • 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
    • 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
        • Creating Raft subgroups using TPA
        • Working with Raft subgroups and PGD CLI
        • Migrating to Raft subgroups
        • Raft elections in depth
    • Backup and recovery
    • 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
    • Upgrading
      • Upgrading PGD clusters with TPA
      • Upgrading PGD clusters manually
      • Supported PGD upgrade paths
      • Compatibility changes
      • In-place Postgres major version upgrades
      • Application schema upgrades
      • Performing a Postgres major version rolling upgrade on a PGD cluster built with TPA
  • Tools
    • EDB Postgres Distributed Command Line Interface (PGD CLI)
      • Installing PGD CLI
        • Installing PGD CLI on Linux
        • Installing PGD CLI on macOS
        • Installing PGD CLI with TPA
      • Using PGD CLI
      • Configuring PGD CLI
      • Discovering connection strings
      • Command reference
        • check-health
        • create-proxy
        • delete-proxy
        • set-group-options
        • set-node-options
        • set-proxy-options
        • show-clockskew
        • show-events
        • show-groups
        • show-nodes
        • show-proxies
        • show-raft
        • show-replslots
        • show-subscriptions
        • show-version
        • switchover
        • verify-cluster
        • verify-settings
  • PGD Feature
    • Node types and capabilities
      • An overview of PGD Node types
      • Witness nodes
      • Logical standby nodes
      • Subscriber-only nodes and groups
        • An overview of Subscriber-only nodes
        • Creating Subscriber-only groups and nodes
        • Joining nodes to a Subscriber-only group
        • Optimizing subscriber-only groups
    • Commit Scopes
      • Overview of durability options
      • Durability terminology
      • Commit scopes
      • Origin groups
      • Commit scope rules
      • Comparing durability options
      • Degrading commit scope rules
      • Commit Scopre Kinds
        • Synchronous Commit
        • Group Commit
        • Commit At Most Once
        • Lag Control
      • Working with
        • Administering
        • Legacy synchronous replication using PGD
        • Limitations
        • Internal timing of operations
    • Conflict Management
      • Conflicts
        • Overview
        • Types of Conflict
        • Conflict detection
        • Conflict resolution
        • Conflict logging
        • Data verification with LiveCompare
      • Column-level conflict detection
        • Overview
        • Enabling and disabling column-level conflict resolution
        • Timestamps in column-level conflict resolution
      • Conflict-free replicated data types
        • CRDTs Overview
        • Using CRDTs
        • Operation-based and state-based CRDTs
        • CRDT Disk-space requirements
        • CRDTs vs conflict handling/reporting
        • Resetting CRDT values
        • Implemented CRDTs
    • Parallel Apply
    • Replication sets
    • Stream triggers
    • PGD AutoPartition
    • Explicit two-phase commit (2PC)
    • Decoding worker
    • Transaction streaming
    • Timestamp-based snapshots
  • Reference
    • PGD reference
      • User visible catalogs and views
      • System functions
      • PGD settings
      • Node management
      • Node management interfaces
      • Routing functions
      • Commit scopes
      • Conflicts
      • Conflict functions
      • Replication set management
      • Replication set membership
      • DDL replication filtering
      • Testing and tuning commands
      • Global sequence management interfaces
      • 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
    • Data migration to EDB Postgres Distributed
      • EDB*Loader and PGD
  • PGD compatibility
  • .rst

General Information

General Information#

  • ompatibility
  • EDB Postgres Distributed 5.6+ release notes
    • EDB Postgres Distributed 5.6.1 release notes
      • Highlights
      • Features
      • Enhancements
      • Bug Fixes
    • EDB Postgres Distributed 5.6.0 release notes
      • Highlights
      • Enhancements
      • Bug Fixes
  • Known issues

previous

EDB Postgres Distributed (PGD)

next

ompatibility

By EnterpriseDB Corporation

© Copyright EnterpriseDB Corporation.