Maintaining your PGD cluster v6.5.0

Suggest edits

EDB Postgres Distributed (PGD) provides a suite of tools and methodologies for maintaining the health of your multi-master clusters, keeping performance tuned and your data protected through regular testing and backups.

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

  • Backing up and restoring — Best practices for securing your data, including physical and logical backup strategies tailored for distributed multi-master topologies.

  • Monitoring — Tracking cluster health through Postgres Enterprise Manager, SQL, and PGD Monitor's built-in web UI, REST API, and Prometheus endpoint.

Testing and tuning

Learn how to test and tune EDB Postgres Distributed clusters.

Backing up and restoring

Back up and restore a PGD cluster using physical backups or pg_dump.

Monitoring

Monitoring EDB Postgres Distributed through Postgres Enterprise Manager, SQL, and PGD Monitor

Migrating to PGD

Migrate from PSR to EDB Postgres Distributed.

← Prev

Upgrading with other deployment methods

↑ Up

EDB Postgres Distributed (PGD)

Next →

Testing and tuning PGD clusters