PGD Reference v6.0.2

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

  • Overview
    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.

  • Nodes 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.

  • Postgres Configuration How Postgres is configured to work in a PGD cluster.

  • Backup and Restore 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.

  • Commit Scopes How to use commit scopes to control transaction visibility in a distributed environment.

  • Conflict Management How to manage conflicts in a distributed environment, including conflict resolution strategies.

  • Autopartition How to use autopartitioning to handle cooling data on nodes in a PGD cluster.

  • Testing and Tuning Guidance on testing and tuning a PGD cluster for optimal performance.

  • Upgrades 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.

  • Replication Sets

  • Security
    Users, roles, and permissions in PGD.

  • Sequences
    How to use PGD's distributed sequences in your applications.

  • Stream Triggers Triggering actions in response to conflicts and transformations.

  • Transaction Streaming How to use transaction streaming for real-time data replication in PGD.

  • Two-Phase Commit How to opt in to explicity two-phase commit in PGD.