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

  1. 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-examples 2. Run the following commands: sh kubectl apply -k kustomize/install/namespace kubectl apply --server-side -k kustomize/install/default For 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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/crunchydatapostgres-operator.svg)](https://yunodb.com/tools/crunchydatapostgres-operator?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/crunchydatapostgres-operator?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/crunchydatapostgres-operator.svg" alt="Featured on YunoDB" height="20"></a>