PGD Reference#
The PGD Reference section provides detailed information about PGD’s features.
An overview of the features and capabilities of PGD.
Functions and Commands#
Configuration and Management#
Connection Manager Details about configuring and using Connection Manager, which provides a single endpoint for client connections to a PGD cluster.
Information about the types of nodes that can exist in a PGD cluster, including details of Subscriber-only nodes.
Node Management How to manage nodes in a PGD cluster, including adding and removing nodes, groups and examining cluster status.
How Postgres is configured to work in a PGD cluster.
How to back up and restore a PGD cluster.
Monitoring How to monitor a PGD cluster, including using the built-in monitoring tools and integrating with external monitoring systems.
How to use commit scopes to control transaction visibility in a distributed environment.
How to manage conflicts in a distributed environment, including conflict resolution strategies.
How to use autopartitioning to handle cooling data on nodes in a PGD cluster.
Guidance on testing and tuning a PGD cluster for optimal performance.
How to upgrade a PGD cluster to a new version, including considerations for compatibility and data migration.
Advanced Functionality#
Application Usage Guidance for developers wanting to use PGD’s advanced functionality in their applications.
DDL How to use DDL functions in a distributed environment.
Decoding Worker How to use the decoding worker in replication in PGD.
CDC Failover Using logical slot failover in PGD for consistent change data capture (CDC).
Parallel Apply How to use parallel apply for improved performance in distributed transactions.
Security Users, roles, and permissions in PGD.
Sequences How to use PGD’s distributed sequences in your applications.
Triggering actions in response to conflicts and transformations.
How to use transaction streaming for real-time data replication in PGD.
How to opt in to explicity two-phase commit in PGD.
- PGD overview
- DDL replication
- Decoding worker
- CDC Failover support
- Parallel Apply
- Replication sets
- Security and roles
- Sequences
- Stream triggers
- Transaction streaming
- Explicit two-phase commit (2PC)
- Node types and capabilities
- Node management
- Connection Manager
- Postgres configuration
- Backup and recovery
- Monitoring
- Monitoring through SQL
- Monitoring overview
- Monitoring node join and removal
- Monitoring the manager worker
- Monitoring Routing
- Monitoring Replication Peers
- Monitoring PGD replication workers
- Monitoring PGD writers
- Monitoring commit scopes
- Monitoring global locks
- Monitoring conflicts
- Apply statistics
- Standard PostgreSQL statistics views
- Monitoring PGD versions
- Monitoring Raft consensus
- Monitoring replication slots
- Monitoring transaction COMMITs
- Monitoring through SQL
- AutoPartition in PGD
- Commit Scopes
- Introducing
- Commit scope kinds
- Working with commit scopes
- Overview of durability options
- Durability terminology
- Commit scopes
- Origin groups
- Commit scope rules
- Comparing durability options
- Degrading commit scope rules
- Synchronous Commit
- Group Commit
- Commit At Most Once
- Lag Control
- Administering
- Legacy synchronous replication using PGD
- Predefined Commit Scopes
- Internal timing of operations
- Conflict Management
- Testing and tuning PGD clusters
- Tables, views and functions reference
- User visible catalogs and views
- System functions
- PGD settings
- CRDTs vs conflict handling/reporting
- Global sequence parameters
- DDL handling
- Global locking
- Node management
- Generic replication
- CRDTs Overview
- Commit Scopes
- Commit At Most Once
- Using with transaction streaming
- Lag Control
- Timestamp-based snapshots
- Monitoring and logging
- Decoding worker
- Connectivity settings
- Topology settings
- Internal settings - Raft timeouts
- Internal settings - Other Raft values
- Internal settings - Other values
- 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
- 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
- Internal catalogs and views
- Internal system functions
- Column-level conflict functions
- EDB Postgres Distributed Command Line Interface (PGD CLI)
- Application use