Skip to main content
Back to top
Ctrl
+
K
foundation
EDB Postgres Distributed 6 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
Overview
Known issues and limitations
PGD compatibility
Postgres Distributed terminology
Quickstart guide
Creating your first cluster
Working with SQL and the PGD cluster
Loading data into your PGD Cluster
Using PGD CLI
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
Managing lifecycle operations
Deploying 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
Application schema upgrades
In-place Postgres or Postgres and PGD major version upgrades
Performing a Postgres major version rolling upgrade on a PGD cluster
Testing and tuning PGD clusters
Backup and recovery
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
Configuration and Management
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
Monitoring
Monitoring through SQL
AutoPartition in PGD
Commit Scopes
Overview of durability options
Durability terminology
Commit scopes
Predefined commit scopes
Commit scope groups
Commit scope rules
Comparing durability options
Degrading commit scope rules
Synchronous Commit
Quorum Commit
How Quorum Commit works
Using 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
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)
Guidance for DBAs
Encrypting columns in PGD
Using tiered storage
Setting up PGAA
Implementing tiered tables
Replicating to analytics
Offloading to analytics
Recovering a failed node
Developing applications for geo-replication
Connecting through Connection Manager
Choosing commit scopes
Preventing conflicts
Configuring selective replication
Handling retries and failures
Running DDL safely
Setting up access controls
Securing inter-node connections
Securing client application connections
Handling replication apply errors
Configuring connection pooling
Guidance for Develoepers
Designing applications for PGD
Preparing your application for PGD
Assessing an existing application for PGD
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 connection pooling in your application
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
Reference
PGD Reference
Tables, views and functions reference
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
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
.rst
.pdf
Routing functions
Routing functions
#
