zalando/postgres-operator

Postgres Operator is a Kubernetes operator that creates and manages highly available PostgreSQL clusters running on Kubernetes.

The operator solves the problem of running production PostgreSQL on Kubernetes by automating cluster lifecycle management through Kubernetes Custom Resource Definitions. Rather than requiring direct Kubernetes API access, administrators define PostgreSQL clusters declaratively using manifests, enabling infrastructure-as-code workflows and CI/CD integration. The operator leverages Patroni to handle streaming replication and high availability, while providing features like rolling updates, live volume resizing, connection pooling via PGBouncer, and point-in-time recovery using pg_basebackup or WAL-G.

Teams should adopt this tool if they run PostgreSQL workloads on Kubernetes and want automated cluster provisioning and management without manual operations. It suits organizations already using Kubernetes who need production-grade PostgreSQL with high availability and want to avoid managing database infrastructure directly. The operator supports major version upgrades across all clusters, restore and cloning across AWS, GCS, and Azure, and standby clusters from remote WAL archives. It works in non-cloud environments and is compatible with OpenShift. The tool includes a UI for creating and editing cluster manifests, basic credential and user management, custom TLS certificate support, and multi-architecture deployments.

The project maintains active test coverage with both unit and end-to-end test workflows. Development activity shows consistent engagement with the codebase through regular updates and maintenance of compatibility across supported PostgreSQL versions.