Skip to main content
Back to top
Ctrl
+
K
PostgreSQL transformed
EDB Postgres Distributed 6 release notes
EDB Postgres Distributed 6.3.0 release notes
EDB Postgres Distributed 6.2.0 release notes
EDB Postgres Distributed 6.1.0 release notes
EDB Postgres Distributed 6.1.1 release notes
EDB Postgres Distributed 6.1.2 release notes
EDB Postgres Distributed 6.0.1 release notes
EDB Postgres Distributed 6.0.2 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
Architecture
Architecture and performance
Standard PGD architecture
Near/far architecture
Always-On Architecture
Multi-Location Architectures
Geo-Distributed Architectures
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
Configure 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
Connection DSNs and SSL (TLS)
Node restart and down node recovery
Automatic synchronization
Node UUIDs
Replication slots created by PGD
Connection Manager
Connection Manager overview
Connection Manager Authentication
Configuring Connection Manager
Load Balancing with 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
Origin groups
Commit scope rules
Comparing durability options
Degrading commit scope rules
Commit Scope Kinds
Synchronous Commit
Group Commit
Commit At Most Once
Lag Control
Working with
Administering
Legacy synchronous replication using PGD
Predefined commit scopes
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
CDC Failover support
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
Parallel Apply
Replication sets
Security and roles
Roles
Role management
PGD predefined roles
Roles and replication
Access control
Sequences
Stream triggers
Transaction streaming
Explicit two-phase commit (2PC)
Guidance for Developers
Application use
Application behavior
DML and DDL replication and nonreplication
Nodes with differences
General rules for applications
Timing considerations and synchronous replication
Using extensions with PGD
Use of table access methods (TAMs) in PGD
Feature compatibility
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
Autopartition
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
EDB Postgres Distributed Command Line Interface (PGD CLI)
Installing PGD CLI
Installing PGD CLI on Linux
Installing PGD CLI on macOS
Using PGD CLI
Configuring PGD CLI
Discovering connection strings
Command reference
pgd assess
pgd cluster
pgd commit-scope
pgd completion
pgd events
pgd group
pgd groups
pgd node
pgd nodes
pgd raft
pgd replication
.rst
.pdf
Routing functions
Routing functions
#
