postgres-operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
What is postgres-operator?
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Overview of postgres-operator
What it is
PGO, the Postgres Operator from Crunchy Data, is a declarative Postgres solution that automatically manages PostgreSQL clusters on Kubernetes. It is designed for production use, from high availability Postgres clusters to full-scale database-as-a-service.
Key features
- Create, scale, and delete PostgreSQL clusters with full customization of Pods and PostgreSQL configuration.
- Safe, automated failover backed by a distributed consensus high availability solution, with failed primaries automatically healing.
- Disaster recovery using pgBackRest, supporting full, incremental, and differential backups, as well as efficient delta restores.
- All connections enforced over TLS, with support for bringing your own TLS infrastructure.
- Monitoring using pgMonitor, Prometheus, Grafana, and Alertmanager.
- Clone new clusters from existing clusters or backups with efficient data cloning.
- Advanced connection pooling support using pgBouncer.
Use cases
PGO is suitable for deploying production-grade PostgreSQL clusters on Kubernetes, managing database-as-a-service workloads, and integrating into GitOps workflows. It supports high availability, disaster recovery, and secure TLS communications for cloud native applications.
Getting started
- Fork the Postgres Operator examples repository and clone it to your host machine:
sh YOUR_GITHUB_UN='' git clone --depth 1 '[email protected]:${YOUR_GITHUB_UN}/postgres-operator-examples.git' cd postgres-operator-examples2. Run the following commands:sh kubectl apply -k kustomize/install/namespace kubectl apply --server-side -k kustomize/install/defaultFor more information, see the Quickstart and Tutorial in the repository.
License and pricing
The license is Apache-2.0. The project is open source.
Based on the project's public README and repository metadata.