Skip to main content
Back to top
Ctrl
+
K
Compatibility
General Information
EDB Postgres Distributed Release notes
EDB Postgres Distributed 5.4.1 release notes
EDB Postgres Distributed 5.4.0 release notes
EDB Postgres Distributed 5.3.0 release notes
EDB Postgres Distributed 5.2.0 release notes
EDB Postgres Distributed 5.1.0 release notes
EDB Postgres Distributed 5.0.1 release notes
EDB Postgres Distributed 5.0.0 release notes
Known issues
Concepts
Terminology
PGD overview
Get Started
Introducing PGD quick starts
Deploying an EDB Postgres Distributed example cluster on Docker
Deploying an EDB Postgres Distributed example cluster on Linux hosts
Deploying an EDB Postgres Distributed example cluster on AWS
Deploying an EDB Postgres Distributed example cluster on Azure and Google cloud platforms
Connecting to your database
Exploring failover handling with PGD
Exploring conflict handling with PGD
Next Steps with PGD
Planning
Choosing your architecture
Choosing a Postgres distribution
Choosing your deployment method
Other considerations
Limitations
Installation and Administration
Manual Installation and Administration
Deploying manually
Step 1 - Provisioning hosts
Step 2 - Installing Postgres
Step 3 - Configuring PGD repositories
Step 4 - Installing the PGD software
Step 5 - Creating the PGD cluster
Step 6 - Checking the cluster
Step 7 - Configure proxies
Step 8 - Using PGD CLI
Automated installation and administration with TPA
Deploying EDB Postgres Distributed using Trusted Postgres Architect
Performing a Postgres major version rolling upgrade on a PGD cluster built with TPA
Upgrading
Upgrading PGD clusters with TPA
Supported PGD upgrade paths
Compatibility changes
In-place Postgres major version upgrades
Application schema upgrades
Using
Application use
Application behavior
DML and DDL replication and nonreplication
Nodes with differences
General rules for applications
Timing considerations and synchronous replication
Use of table access methods (TAMs) in PGD
Feature compatibility
Node management
Node types
Groups and subgroups
Creating and joining PGD groups
Witness nodes
Logical standby nodes
Subscriber-only nodes and groups
Viewing PGD topology
Removing nodes and groups
Joining a heterogeneous cluster
Connection DSNs and SSL (TLS)
Decoding worker
Replication slots created by PGD
Node restart and down node recovery
Maintenance commands through proxies
Postgres configuration
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
Security and roles
Roles
Role management
PGD predefined roles
Roles and replication
Access Control
Sequences
Durability
An Overview of Durability options
Durability Terminology
Commit scopes
Commit scope rules
Comparing Durability Options
Group Commit
Commit At Most Once
Lag Control
PGD Synchronous Commit
Administering
Legacy synchronous replication using PGD
Limitations
Internal Timing of Operations
Consistency
Conflicts
Column-level conflict detection
Conflict-free replicated data types
Eager conflict resolution
Parallel Apply
Replication sets
Application connection management
EDB Postgres Distributed Proxy
Installing PGD Proxy
Proxies, Raft, and Raft subgroups
Creating Raft subgroups using TPA
Working with Raft subgroups and PGD CLI
Migrating to Raft subgroups
Raft elections in depth
Backup and recovery
Monitoring
OpenTelemetry integration
Monitoring through SQL
EDB Postgres Distributed Command Line Interface
Installing PGD CLI
Using PGD CLI
Configuring PGD CLI
Discovering connection strings
Command reference
check-health
create-proxy
delete-proxy
set-group-options
set-node-options
set-proxy-options
show-clockskew
show-events
show-groups
show-nodes
show-proxies
show-raft
show-replslots
show-subscriptions
show-version
switchover
verify-cluster
verify-settings
Transaction streaming
Testing and tuning PGD clusters
Stream triggers
PGD AutoPartition
Explicit two-phase commit (2PC)
Timestamp-based snapshots
Reference
PGD Reference
User visible catalogs and views
System functions
PGD settings
Node management
Node management interfaces
Routing functions
Commit scopes
Replication set management
Replication set membership
DDL replication filtering
Testing and tuning commands
Global sequence management interfaces
Autopartition
Stream Triggers Reference
Stream triggers manipulation interfaces
Stream triggers row functions
Stream triggers row variables
Internal catalogs and views
Internal system functions
Index
