Skip to main content
Ctrl+K
EDB Postgres Distributed -PGD 5.3.0 documentation - Home
  • Introduction
  • EDB Postgres Distributed 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
  • Quick Start
    • 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
  • Concepts
    • PGD overview
    • Terminology
  • Planning
    • Choosing your architecture
    • Choosing a Postgres distribution
    • Choosing your deployment method
    • Other considerations
    • Limitations
  • Installing
    • Upgrading
      • Upgrading PGD clusters with TPA
      • Upgrading PGD clusters manually
      • Supported PGD upgrade paths
      • Compatibility changes
      • In-place Postgres major version upgrades
      • Application schema upgrades
    • Deploying EDB Postgres Distributed using Trusted Postgres Architect
  • 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
    • Node management
      • Node types
      • Groups and subgroups
      • Creating and joining PGD groups
      • Witness nodes
      • Logical standby nodes
      • Physical 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
    • Postgres configuration
    • DDL replication
    • Security and roles
      • Roles
      • Role management
      • PGD predefined roles
      • Roles and replication
      • Access Control
    • Sequences
    • Durability
      • Commit scopes
      • Group Commit
      • Commit At Most Once
      • Lag Control
    • 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
    • AutoPartition
    • Explicit two-phase commit (2PC)
    • Timestamp-based snapshots
  • PGD Reference
    • User visible catalogs and views
    • System functions
    • PGD settings
    • Node management
    • Node management interfaces
    • Routing 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
  • .rst

Planning

Planning#

  • Choosing your architecture
    • Standard EDB Always On architectures
    • Architecture details
      • Always On Single Location
      • Always On multi-location
    • Choosing your architecture
    • Adding flexibility to the standard architectures
  • Choosing a Postgres distribution
  • Choosing your deployment method
  • Other considerations
    • Data consistency
    • Deployment
    • Sizing considerations
    • Clocks and timezones
  • Limitations
    • Nodes
    • Multiple databases on single instances
    • CAMO
    • Group Commit
    • Eager
    • Other limitations

previous

Terminology

next

Choosing your architecture

By EnterpriseDB Corporation.

© Copyright EnterpriseDB Corporation..