Managing lifecycle operations

EDB Postgres Distributed (PGD) provides a suite of tools and methodologies for maintaining the health and evolution of your multi-master clusters. Managing lifecycle operations effectively ensures that your high-availability environment remains performant and secure through software updates, migrations, and configuration tuning.

• Deploying and configuring PGD on Hybrid Manager _ Instructions for provisioning PGD clusters across different environments, including manual installations, TPA-automated deployments, CloudNativePG deployments, and Hybrid Manager integrations.

• Upgrading PGD _ Detailed workflows for performing minor and major version upgrades for both the underlying PostgreSQL engine and the PGD extension with minimal downtime.

• Testing and tuning PGD clusters _ Guidance on benchmarking your distributed workloads using pgd-bench and optimizing system parameters for maximum throughput.

• Backup and recovery _ Best practices for securing your data, including physical and logical backup strategies tailored for distributed multi-master topologies.

• 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
  • Upgrading Postgres or Postgres and PGD major versions
  • Other upgrades
    • 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
  • pgd_bench
  • Notes on pgd_bench usage
    • Performance testing and tuning
• 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
• Migrating to Postgres Distributed (PGD)
  • Migrating from Postgres Physical Streaming Replication (PSR) to PGD
    • Prerequisites
    • Migration overview