Skip to main content
Back to top
Ctrl
+
K
Introduction
EDB Postgres Distributed 6 release notes
EDB Postgres Distributed 6.5.0 release notes
EDB Postgres Distributed 6.4.0 release notes
EDB Postgres Distributed 6.3.1 release notes
EDB Postgres Distributed 6.3.0 release notes
EDB Postgres Distributed 6.2.0 release notes
EDB Postgres Distributed 6.1.2 release notes
EDB Postgres Distributed 6.1.1 release notes
EDB Postgres Distributed 6.1.0 release notes
EDB Postgres Distributed 6.0.2 release notes
EDB Postgres Distributed 6.0.1 release notes
Quickstart guide
Creating your first cluster
Working with SQL and the PGD cluster
Loading data into your PGD Cluster
Using PGD CLI
Overview
Postgres Distributed terminology
Known issues and limitations
PGD compatibility
Product lifecycle and release roadmap
Planning your PGD deployment
Deployment patterns
Single data group
Two data groups, active-active
Three data groups, active-active-active
Single data group, global read scaling
Primary active group, DR group
Multiple locations, data residency
Choosing a Postgres distribution
Choosing your deployment method
Comparing replication solutions
Choosing between Physical Streaming Replication (PSR) and EDB Postgres Distributed (PGD)
Other considerations
Sizing
Time and PGD
Installing and configuring EDB Postgres Distributed
Manually
Prerequisites
Configuring PGD repositories
Installing the database and pgd
Configuring the cluster
Checking the cluster
Connecting to your PGD cluster
Deploying and configuring PGD using TPA
Deploying and configuring PGD on Kubernetes
Deploying and configuring PGD on Hybrid Manager
Upgrading
Upgrading PGD clusters manually
Supported PGD upgrade paths
Compatibility changes
Upgrading application schemas
In-place Postgres or Postgres and PGD major version upgrades
Performing a Postgres major version rolling upgrade on a PGD cluster
Maintaining your PGD cluster
Testing and tuning PGD clusters
Backup and recovery
Monitoring
Monitoring through SQL
Using the PGD Monitor
Using the web UI
Using Prometheus
Migrating to Postgres Distributed (PGD)
Migrating from Postgres Physical Streaming Replication (PSR) to PGD
Preparing your environment
Transferring data to the seed node
Converting to logical replication
Upgrading the seed node and installing PGD
Initializing PGD
Joining additional PGD nodes
Application cutover
Performing cleanup
Guidance for DBAs
Ensuring security
Setting up access controls
Securing inter-node connections
Securing client application connections
Encrypting columns in PGD
Configuring connection pooling
Managing geo-replication
Choosing a geo-replication deployment pattern
Setting up your geo-replication topology
Configuring routing
Configuring commit scopes for geo-replication
Controlling replication lag
Replication and sequence tuning
Performing cluster maintenance
Using tiered storage
Setting up PGAA
Implementing tiered tables
Replicating to analytics
Offloading to analytics
Recovering from failures
Handling replication apply errors
Recovering a failed node
Guidance for Developers
Designing applications for PGD
Assessing an existing application for PGD
Preparing your application for PGD
Achieving durability with commit scopes
Using predefined scopes
Fine-tuning with custom scopes
Using connection pooling in your application
Developing applications for geo-replication
Connecting through Connection Manager
Choosing commit scopes
Preventing conflicts
Configuring selective replication
Handling retries and failures
Running DDL safely
Deep Dive
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
Node management
Creating PGD nodes
Groups and subgroups
Creating and joining PGD groups
Viewing PGD topology
Removing nodes and groups
Node restart and down node recovery
Automatic synchronization
Node UUIDs
Replication slots created by PGD
Connection Manager
Connection Manager overview
Connection Manager Authentication
Connection pooling
Load Balancing with Connection Manager
Configuring Connection Manager
Monitoring the Connection Manager
Postgres configuration
AutoPartition in PGD
Working with
Overview of durability options
Durability terminology
Commit scopes
Predefined commit scopes
Commit scope groups
Commit scope rules
Comparing durability options
Degrading commit scope rules
Commit Scope Kinds
Synchronous Commit
Quorum Commit
Commit At Most Once
Lag Control
Group Commit (legacy)
Administering
Legacy synchronous replication using PGD
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
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
Application use
DML and DDL replication and nonreplication
Nodes with differences
Timing considerations and synchronous replication
Using extensions with PGD
Use of table access methods (TAMs) in PGD
Feature compatibility
Decoding worker
CDC Failover support
Parallel Apply
Replication sets
Security and roles
Roles
Role management
PGD predefined roles
Roles and replication
Access control
Sequences
Replicated large objects
Stream triggers
Transaction streaming
Explicit two-phase commit (2PC)
Referecne
PGD Reference
Tables, views and functions reference
User visible catalogs and views
System functions
Monitoring metrics reference
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
Large object functions
Autopartition
Stream triggers reference
Internal catalogs and views
Internal system functions
Column-level conflict functions
EDB Postgres Distributed Command Line Interface (PGD CLI)
Installing PGD CLI
Using PGD CLI
Configuring PGD CLI
Discovering connection strings
Command reference
Index
