Reference

• PGD Reference
  • Functions and Commands
  • Configuration and Management
  • Advanced Functionality
    • PGD overview
      • Architecture overview
        • High-level architecture
        • Architectural elements
        • Architectural flexibility
      • PGD overview - architecture and performance
        • Architectural options and performance
      • PGD compared
    • Advanced functionality
      • 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
      • Decoding worker
        • Enabling
        • Disabling
      • CDC Failover support
        • Background
        • CDC Failover support
        • Enabling CDC Failover support
        • CDC Failover support with Postgres 17+
        • Obtaining Initial Consistent Snapshot
        • Failing Over to Newly Joined Nodes
        • Tracking Per-Origin Progress
        • Limitations
      • 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
      • Security and roles
        • Roles
        • Role management
        • PGD predefined roles
        • Roles and replication
        • Access control
      • Sequences
        • PGD global sequences
        • Automatic sequence conversion
        • UUIDs, KSUUIDs, and other approaches
        • KSUUID v2 functions
        • See also
      • Stream triggers
        • Trigger execution during apply
        • Terminology of row-types
        • Conflict triggers
        • Transform triggers
        • Row contents
        • Execution order
        • Stream triggers examples
      • Transaction streaming
        • PGD enhancements
        • Configuration
        • Monitoring
      • Explicit two-phase commit (2PC)
        • Use
    • Config and management
      • 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
        • Connection DSNs and SSL (TLS)
        • Node restart and down node recovery
        • Automatic synchronization
        • Node UUIDs
        • Replication slots created by PGD
      • Connection Manager
        • Connection Manager overview
        • Connection Manager Authentication
        • Configuring Connection Manager
        • Load Balancing with Connection Manager
        • Monitoring the Connection Manager
      • Postgres configuration
        • Postgres settings
        • Max prepared transactions
      • Backup and recovery
        • Logical backup and restore
        • Physical backup and restore
        • Eventual consistency
        • Monitoring
      • Monitoring
        • Monitoring through SQL
      • 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
      • Commit Scopes
        • Introducing
        • Commit scope kinds
        • Working with commit scopes
      • Conflict Management
        • Conflicts
        • Column-level conflict detection
        • Conflict-free replicated data types
      • Testing and tuning PGD clusters
        • pgd_bench
        • Notes on pgd_bench usage
    • Functions and command
      • Tables, views and functions reference
        • User visible catalogs and views
        • System functions
        • PGD settings
        • Node management
        • Node management interfaces
        • Routing functions
        • Commit Scopes
        • bdr_read_all_conflicts
        • Column-level conflict functions
        • Replication set management
        • Replication set membership
        • DDL replication filtering
        • Testing and tuning commands
        • Sequences
        • Autopartitioning
        • 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
        • bdr_read_all_conflicts
      • EDB Postgres Distributed Command Line Interface (PGD CLI)
        • Installing PGD CLI
        • Using PGD CLI
        • Configuring PGD CLI
        • Discovering connection strings
        • Command reference
    • Guidance for dev
      • Application use
        • Application behavior
        • DML and DDL replication and nonreplication
        • Nodes with differences
        • General rules for applications
        • Timing considerations and synchronous replication
        • Using extensions with PGD
        • Use of table access methods (TAMs) in PGD
        • Feature compatibility
• 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