Maintaining your PGD cluster v6.5.0

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.

  • Performing backup and recovery 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.

Backup and recovery

Backup and recovery

Monitoring

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

Migrating to PGD

Migrate from PSR to EDB Postgres Distributed.