PostgreSQL Management and Automation with ClusterControl

This white paper discusses some of the challenges that may arise when administering a PostgreSQL database as well as some of the most important tasks an administrator needs to handle; and how to do so effectively … with ClusterControl. See how much time and effort can be saved, as well as risks mitigated, by the usage of such a unified management platform.

Get the whitepaper

Introducton

This white paper discusses some of the challenges that may arise when administering a PostgreSQL database as well as some of the most important tasks an administrator needs to handle; and how to do so effectively … with ClusterControl. See how much time and effort can be saved, as well as risks mitigated, by the usage of such a unified management platform.

Table of contents

  • Introduction
  • Backup and recovery
  • HA setups
    • Master-Slave architectures
    • Master-Master architectures
      • Load Balancing and connection pooling
  • Monitoring
  • Synopsis
  • Automation with ClusterControl
    • Deployment
    • Import
    • Scalability
    • Failover
    • Load balancing
    • Monitoring
    • Alerts
    • Reports
    • Backups
    • Topology view
    • Integrations
  • ChatOps via CCBot
    • Command Line
      • Help
      • PostgreSQL deploy cluster
      • PostgreSQL create backup
      • PostgreSQL cluster status
      • Jobs status
  • Conclusion
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.