PGD Reference

The PGD Reference section provides detailed information about PGD’s features.

Functions and Commands

• Tables, Views, and Functions

• Command Line Interface (CLI)

Configuration and Management

• Nodes

• Node Management

• Connection Manager

• Postgres Configuration

• Backup and Restore

• Autopartition

• Commit Scopes

• Conflict Management

• Testing and Tuning

• Upgrades

Advanced Functionality

• Application Usage

Guidance for developers wanting to use PGD’s advanced functionality in their applications.

• DDL

• Decoding Worker

• CDC Failover

• Parallel Apply

• Replication Sets

• Security

• Sequences

• Stream Triggers

• Transaction Streaming

• Two-Phase Commit

• 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
• Configuration 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
    • Backup
    • Restore
  • 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
    • Restrictions on EDB Postgres Advanced Server-native automatic partitioning
  • 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
  • Upgrading
    • Upgrading to EDB Postgres Distributed 6
• Functions and Commands
  • 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 Development
  • 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