A Kubernetes operator for declarative management of production PostgreSQL clusters with high availability, disaster recovery, and monitoring.
PGO (the Postgres Operator from Crunchy Data) is a Kubernetes operator that automates the deployment, management, and scaling of production PostgreSQL clusters. It solves the operational complexity of running stateful databases in Kubernetes by providing declarative APIs for high availability, backups, monitoring, and security. The operator handles lifecycle operations so developers can focus on applications rather than database administration.
Platform engineers, DevOps teams, and developers running PostgreSQL workloads on Kubernetes who need a production-grade, automated database solution. It's ideal for organizations adopting GitOps and cloud-native practices.
Developers choose PGO because it offers a comprehensive, open-source alternative to managed database services, with deep Kubernetes integration and enterprise-grade features like automated failover, multi-cloud backups, and extensive customization. Its declarative approach aligns with modern infrastructure-as-code workflows.
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Automates PostgreSQL cluster management using Kubernetes-native APIs, aligning with modern infrastructure-as-code workflows as emphasized in the quickstart guide for easy GitOps adoption.
Features automated failover with distributed consensus via Patroni and supports cross-cluster standby replicas, ensuring minimal downtime and data resilience in production environments.
Enforces TLS for all connections by default and allows customization with own TLS infrastructure, providing secure database access out-of-the-box as detailed in the TLS documentation.
Uses pgBackRest for efficient backups to multiple object storage backends like S3, GCS, and Azure, with support for full, incremental, and differential backups, enhancing disaster recovery options.
Bundles pgMonitor, Prometheus, and Grafana for real-time cluster health tracking and alerting, eliminating the need for separate setup of observability tools as listed in the included components.
Default installation pulls container images from Crunchy Data's Developer Portal, subject to specific terms of use, which may introduce vendor lock-in or licensing concerns for teams seeking completely open-source deployments.
While a quickstart is provided, customizing or running without Crunchy's distribution requires manual image builds and configuration adjustments, adding to deployment complexity and learning curve.
The operator and its components (like monitoring stacks) consume significant Kubernetes resources, making it overkill for lightweight or resource-constrained environments, such as small clusters or development setups.