Config and management

• Node types and capabilities
  • An overview of PGD Node types
    • Data nodes
    • Witness nodes
    • Logical standby nodes
    • Subscriber-only nodes
  • Witness nodes
    • Witness nodes within PGD groups or regions
    • Witness node outside regions
  • Logical standby nodes
  • Subscriber-only nodes and groups
    • An overview of Subscriber-only nodes
      • Overview
      • Subscriber-only nodes
      • Subscriber-only groups
      • Optimizing subscriber-only groups
      • Subscriber-only nodes and DDL
    • Creating Subscriber-only groups and nodes
      • Creating a Subscriber-only group manually
      • Adding a node to a new Subscriber-only group manually
    • Joining nodes to a Subscriber-only group
      • Joining a node to an existing subscriber-only group
    • Optimizing subscriber-only groups
      • Requirements for the optimized topology
      • How the optimized topology works
      • Subscriber-only group leaders
      • Group leaders in the optimized topology
      • Enabling the optimized model
• Node management
  • Creating PGD nodes
    • It’s just Postgres
    • Which Postgres version?
    • Installing Postgres
    • Installing the BDR extension
      • Configuring the database for PGD
    • Initializing a PGD node
    • Next steps
  • Groups and subgroups
    • Groups
    • Sub-groups
  • Creating and joining PGD groups
    • Creating and joining PGD groups
  • Viewing PGD topology
    • Listing PGD groups
      • Using pgd-cli
      • Using SQL
    • Listing nodes in a PGD group
      • Using pgd-cli
      • Using SQL
  • Removing nodes and groups
    • Removing a node from a PGD group
    • Removing a whole PGD group
  • Connection DSNs and SSL (TLS)
  • Node restart and down node recovery
  • Automatic synchronization
    • Auto-triggering the Sync
    • Cancellation
    • Sync Request Life Cycle
    • GUC
  • Node UUIDs
    • Why UUIDs?
    • How are UUIDs generated?
    • What happens if a node is removed and a replacement added?
    • UUID-related changes in PGD 6
  • Replication slots created by PGD
    • Other slot names
• Connection Manager
  • Connection Manager overview
    • About Connection Manager
    • Using Connection Manager
    • Read-Only connections
    • TLS and Authentication
  • Connection Manager Authentication
    • Connection Manager connection types
    • Connection Manager authentication methods
    • Unsupported pg_hba.conf rules
    • LDAP authentication notes and constraints
  • Configuring Connection Manager
    • Configuring Connection Manager
  • Load Balancing with Connection Manager
    • Connection Manager routing
      • HAProxy example: Connection Manager routing
    • Direct routing
      • HAProxy example: Direct routing
  • Monitoring the Connection Manager
    • Available SQL tables and views
    • Available HTTP/HTTPS endpoints
    • Logging
• Postgres configuration
  • Postgres settings
  • Max prepared transactions
    • max_prepared_transactions
• Backup and recovery
  • Logical backup and restore
    • Temporary postgresql.conf settings
    • pg_dump / pg_restore
    • Prefer restoring to a single node cluster
    • Sequences
  • Physical backup and restore
    • 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
  • Eventual consistency
    • Point-in-time recovery (PITR)
  • Monitoring
• Monitoring
  • Monitoring through SQL
    • Monitoring overview
    • Monitoring node join and removal
    • Monitoring the manager worker
    • Monitoring Routing
    • Monitoring Replication Peers
      • Monitoring outgoing replication
      • Monitoring incoming replication
      • Monitoring WAL senders using LCR
    • Monitoring PGD replication workers
    • Monitoring PGD writers
    • Monitoring commit scopes
    • Monitoring global locks
    • Monitoring conflicts
    • Apply statistics
    • Standard PostgreSQL statistics views
    • Monitoring PGD versions
    • Monitoring Raft consensus
    • Monitoring replication slots
    • Monitoring transaction COMMITs
• AutoPartition in PGD
  • 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
  • Dropping or detaching a partition
• Commit Scopes
  • Introducing
  • Commit scope kinds
  • Working with commit scopes
    • Overview of durability options
      • Overview
    • Durability terminology
      • Durability terminology
        • Nodes
    • Commit scopes
      • Commit scope structure
      • How a commit scope is selected
      • Creating a Commit Scope
      • Using a commit scope
    • Origin groups
      • ORIGIN_GROUP
    • Commit scope rules
      • The commit scope group
      • The confirmation level
      • The commit scope kinds
        • SYNCHRONOUS COMMIT
        • GROUP COMMIT
        • CAMO
        • LAG CONTROL
      • Combining rules
    • Comparing durability options
      • Comparison
        • ON RECEIVED
        • ON REPLICATED
        • ON DURABLE
        • ON VISIBLE
    • Degrading commit scope rules
      • Behavior
      • SYNCHRONOUS COMMIT and GROUP COMMIT
      • CAMO
    • Commit scope kind
      • Synchronous Commit
        • Overview
        • Example
        • Configuration
        • Confirmation
        • Details
      • Group Commit
        • Overview
        • Example
        • Requirements
        • Limitations
        • Configuration
        • Confirmation
        • Behavior
        • Eager conflict resolution
      • Commit At Most Once
        • Overview
        • Requirements
        • Configuration
        • Confirmation
        • Limitations
        • Failure scenarios
        • Application use
        • CAMO limitations
        • Performance implications
        • Client application testing
      • Lag Control
        • Overview
        • Background
        • Requirements
        • Configuration
        • Confirmation
        • Transaction application
        • Limitations
        • Caveats
        • Meeting organizational objectives
        • Lag Control and extensions
    • Working with commit scopes
      • Administering
        • Planned shutdown and restarts
      • Legacy synchronous replication using PGD
        • Usage
        • Comparison
        • Postgres configuration parameters
        • Migration to commit scopes
      • Predefined Commit Scopes
        • local protect
        • lag protect
        • majority protect
        • adaptive protect
      • Internal timing of operations
• Conflict Management
  • Conflicts
    • Overview
      • How conflicts happen
      • Avoiding or tolerating conflicts
    • Types of Conflict
      • PRIMARY KEY or UNIQUE conflicts
        • INSERT/INSERT conflicts
        • INSERT operations that violate UNIQUE or EXCLUDE constraints
        • UPDATE/UPDATE conflicts
        • UPDATE conflicts on the PRIMARY KEY
        • UPDATE operations that violate UNIQUE or EXCLUDE constraints
        • UPDATE/DELETE conflicts
        • INSERT/UPDATE conflicts
        • INSERT/DELETE conflicts
        • DELETE/DELETE conflicts
        • Conflicts with three or more nodes
      • Foreign key constraint conflicts
      • TRUNCATE conflicts
      • Data conflicts for roles and tablespace differences
      • Lock conflicts and deadlock aborts
      • Divergent conflicts
      • TOAST support details
    • Conflict detection
      • Origin conflict detection
      • Row version conflict detection
    • Conflict resolution
    • Conflict logging
      • Conflict reporting
    • Data verification with LiveCompare
  • Column-level conflict detection
    • Overview
      • When to resolve at the column level
      • Special problems for column-level conflict resolution
      • Handling column-level conflicts using CRDT data types
    • Enabling and disabling column-level conflict resolution
      • Using bdr.alter_table_conflict_detection to enable column-level conflict resolution
      • Listing tables with column-level conflict resolution
    • Timestamps in column-level conflict resolution
      • Comparing column_modify_timestamp and column_commit_timestamp
        • column_modify_timestamp
        • column_commit_timestamp
      • Inspecting column timestamps
        • bdr.column_timestamps_to_text(bdr.column_timestamps)
        • bdr.column_timestamps_to_jsonb(bdr.column_timestamps)
        • bdr.column_timestamps_resolve(bdr.column_timestamps, xid)
  • Conflict-free replicated data types
    • CRDTs Overview
      • Introduction to CRDTs
      • CRDTs in PostgreSQL
    • Using CRDTs
      • Using CRDTs in tables
        • Non-CRDT example
        • CRDT example
      • Configuration options
      • Different types of CRDTs
      • Query planning and optimization
    • Operation-based and state-based CRDTs
      • Operation-based CRDT types (CmCRDT)
      • State-based CRDT types (CvCRDT)
    • CRDT Disk-space requirements
      • Operation-based CRDT disk-space reqs
      • State-based CRDT disk-space reqs
    • CRDTs vs conflict handling/reporting
      • CRDT types versus conflicts handling
      • CRDT types versus conflict reporting
    • Resetting CRDT values
      • Challenges when resetting CRDT values
      • How to reliably handle resetting CRDT values
    • Implemented CRDTs
      • Grow-only counter (crdt_gcounter )
      • Grow-only sum (crdt_gsum )
      • Positive-negative counter (crdt_pncounter )
      • Positive-negative sum (crdt_pnsum )
      • Delta counter (crdt_delta_counter )
      • Delta sum (crdt_delta_sum )
• Testing and tuning PGD clusters
  • pgd_bench
  • Notes on pgd_bench usage
    • Performance testing and tuning