Using

• Application use
  • Application behavior
  • Nonreplicated statements
  • DML and DDL replication
  • Replicating between different release levels
  • Replicating between nodes with differences
  • Comparison between nodes with differences
  • General rules for applications
  • Timing considerations and synchronous replication
  • Application testing
    • Trusted Postgres Architect
    • pgbench with CAMO/failover options
    • isolationtester with multi-node access
  • Performance testing and tuning
  • Use of table access methods (TAMs) in PGD
• Postgres configuration
  • Postgres settings
  • Time-based snapshots
    • snapshot_timestamp
  • Max prepared transactions
    • max_prepared_transactions
• Node management
  • Creating and joining a PGD group
    • Joining a heterogeneous cluster
    • Connection DSNs and SSL (TLS)
  • Witness nodes
  • Logical standby nodes
  • Physical standby nodes
  • Subgroups
    • Subscriber-only groups
    • Notes
  • Decoding worker
    • Notes
  • Node restart and down node recovery
    • Replication slots created by PGD
    • Group replication slot
    • Hashing long identifiers
  • Removing a node from a PGD group
  • Removing a whole PGD group
    • Uninstalling PGD
  • Listing PGD topology
    • Listing PGD groups
    • Listing nodes in a PGD group
• DDL replication
  • DDL replication options
  • Executing DDL on PGD systems
  • DDL locking details
  • Minimizing the impact of DDL
  • Handling DDL with down nodes
  • Statement-specific DDL replication concerns
  • PGD DDL command handling matrix
    • ALTER SEQUENCE
    • ALTER TABLE
    • ALTER TABLE disallowed commands
    • ALTER TABLE locking
    • ALTER TABLE examples
    • ALTER TYPE
    • COMMENT ON
    • CREATE PROFILE or ALTER PROFILE
    • CREATE SEQUENCE
    • CREATE TABLE
    • CREATE TABLE AS and SELECT INTO
    • EXPLAIN
    • EXPLAIN ANALYZE Replication
    • EXPLAIN ANALYZE Locking
    • GRANT and REVOKE
    • LOCK TABLE
    • SECURITY LABEL
    • TRUNCATE Replication
    • TRUNCATE Locking
    • Role manipulation statements
    • Restricted DDL workarounds
    • Adding a CONSTRAINT
    • Adding a column
    • Changing a column’s type
    • Changing other types
    • PGD functions that behave like DDL
• Security and roles
  • Catalog tables
  • PGD functions and operators
  • Granting privileges on catalog objects
  • Role management
  • Roles and replication
  • Connection role
  • Privilege restrictions
    • Foreign key privileges
    • Triggers
  • PGD default/predefined roles
    • bdr_superuser
    • bdr_read_all_stats
    • bdr_monitor
    • bdr_application
    • bdr_read_all_conflicts
  • Verification
    • Coverity
    • CIS Benchmark
• Sequences
  • PGD global sequences
    • SnowflakeId sequences
    • Timeshard sequences
    • Globally allocated range sequences
    • Converting a local sequence to a galloc sequence
  • UUIDs, KSUUIDs, and other approaches
    • UUIDs
    • KSUUIDs
    • Step and offset sequences
    • Composite keys
  • See also
• Durability and performance options
  • Overview
  • Terms and definitions
  • Comparison
  • Internal timing of operations
  • Configuration
    • Postgres configuration parameters
  • Planned shutdown and restarts
  • Legacy synchronous replication using PGD
    • Usage
    • Migration to commit scopes
• Consistency
  • Conflicts
    • How conflicts happen
    • Types of conflict
    • Avoiding or tolerating conflicts
    • Conflict detection
    • Conflict resolution
    • Conflict logging
    • Data verification with LiveCompare
  • Column-level conflict detection
    • Enabling and disabling column-level conflict resolution
    • DDL locking
    • Current versus commit timestamp
    • Inspecting column timestamps
    • Handling column conflicts using CRDT data types
    • Notes
  • Conflict-free replicated data types
    • State-based and operation-based CRDTs
    • Disk-space requirements
    • CRDT types versus conflicts handling
    • CRDT types versus conflict reporting
    • Resetting CRDT values
    • Implemented CRDT data types
  • Eager conflict resolution
    • Usage
    • Error handling
    • Effects of Eager Replication in general
• Parallel Apply
  • What is Parallel Apply?
    • Configuring Parallel Apply
    • When to use Parallel Apply
    • Monitoring Parallel Apply
    • Disabling Parallel Apply
• Replication sets
  • Using replication sets
  • Behavior of partitioned tables
  • Behavior with foreign keys
  • Replication set membership
  • Listing replication sets
  • DDL replication filtering
• Application connection management
  • Configuration
    • EDB Postgres Distributed Proxy
    • Installing PGD Proxy
    • Proxies, Raft, and Raft subgroups
• Backup and recovery
  • Backup
    • pg_dump
    • Physical backup
    • Eventual consistency
    • Point-in-time recovery (PITR)
  • Restore
    • EDB Postgres Distributed cluster failure or seeding a new cluster from a backup
    • Cleanup of PGD metadata
    • Cleanup of replication origins
    • Cleanup of replication slots
• Monitoring
  • OpenTelemetry integration
    • Metrics collection
    • Tracing
    • TLS support
  • Monitoring through SQL
    • Monitoring overview
    • Monitoring node join and removal
    • Monitoring Replication Peers
    • Monitoring PGD replication workers
    • Monitoring PGD writers
    • Monitoring global locks
    • Monitoring conflicts
    • Apply statistics
    • Standard PostgreSQL statistics views
    • Monitoring PGD versions
    • Monitoring Raft consensus
    • Monitoring replication slots
    • Monitoring transaction COMMITs
• EDB Postgres Distributed Command Line Interface
  • Requirements
  • Using the PGD CLI
  • Specifying a configuration file
  • Passing a database connection string
  • Specifying the output format
  • Accessing the command line help
    • Installing PGD CLI
    • Command reference
• Transaction streaming
  • PGD enhancements
    • Caveats
  • Configuration
    • Node configuration using bdr.default_streaming_mode
    • Group configuration using bdr.alter_node_group_config()
    • Configuration setting effects
  • Monitoring
• Stream triggers
  • Trigger execution during Apply
    • Missing-column conflict resolution
    • Data loss and divergence risk
  • Terminology of row-types
  • Conflict triggers
  • Transform triggers
  • Row contents
  • Execution order
  • Stream triggers examples
• AutoPartition
  • Auto creation of partitions
  • Autopartition Examples
  • RANGE-partitioned tables
  • Stopping automatic creation of partitions
  • Waiting for partition creation
  • Finding a partition
  • Enabling or disabling AutoPartitioning
• Explicit two-phase commit (2PC)
  • Use
• Timestamp-based snapshots