Automates deploying and managing PostgreSQL clusters on Kubernetes with high availability, backups, and monitoring.
Percona Operator for PostgreSQL is a Kubernetes operator that automates the deployment and management of open-source PostgreSQL clusters on Kubernetes. It simplifies the setup and ongoing operations of PostgreSQL databases, providing essential features for production-ready database management. The operator is based on the Postgres Operator developed by Crunchy Data and is built on Kubernetes primitives following CNCF best practices.
DevOps engineers, SREs, and platform teams managing PostgreSQL databases in Kubernetes environments, particularly those needing production-ready, high-availability clusters. It is also suitable for organizations running database-as-a-service offerings on Kubernetes.
Developers choose this operator for its comprehensive automation of PostgreSQL cluster lifecycle management, including high availability, disaster recovery, and integrated monitoring with Percona Monitoring and Management. It offers a production-ready solution with enterprise-grade support options and a web-based management interface via Percona Everest.
Percona Operator for PostgreSQL
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 provisioning, updates, and user management with password rotation, as specified in the README for essential production features.
Supports asynchronous and synchronous replication, disaster recovery, and scheduled backups, ensuring fault-tolerant clusters suitable for critical workloads.
Includes Percona Monitoring and Management (PMM) for operational insights, reducing setup time for monitoring compared to manual configurations.
Offers Percona Everest for a GUI to simplify day-to-day tasks, as mentioned in the README for streamlined database management beyond CLI.
Requires a Kubernetes cluster, making it unsuitable for non-K8s environments and adding complexity for teams unfamiliar with Kubernetes operators.
Tightly integrated with Percona's tools like PMM and Everest, which may limit flexibility if users prefer other monitoring or management solutions.
Despite quickstart guides, deploying and tuning the operator involves Kubernetes expertise and YAML configuration, which can be daunting for newcomers.
The operator itself consumes cluster resources, and for minimal PostgreSQL instances without HA needs, this adds unnecessary CPU and memory usage.