Skip to content

cybertec-postgresql/CYBERTEC-pg-operator

Repository files navigation

CYBERTEC PG Operator

CPO (CYBERTEC PG Operator) allows you to create and run PostgreSQL clusters on Kubernetes.

The operator reduces your efforts and simplifies the administration of your PostgreSQL clusters so that you can concentrate on other things.

CYBERTEC PG Operator

CPO (CYBERTEC PG Operator) allows you to create and run PostgreSQL clusters on Kubernetes.

The operator reduces your efforts and simplifies the administration of your PostgreSQL clusters so that you can concentrate on other things.

The Postgres Operator delivers an easy to run highly-available PostgreSQL clusters on Kubernetes (K8s) powered by Patroni. It is configured only through Postgres manifests (CRDs) to ease integration into automated CI/CD pipelines with no access to Kubernetes API directly, promoting infrastructure as code vs manual operations.

Operator features

  • Rolling updates on Postgres cluster changes, incl. quick minor version updates
  • Live volume resize without pod restarts if supported by the storage-system (PVC)
  • Database connection pooling with PGBouncer
  • Support fast in place major version upgrade. Supports global upgrade of all clusters.
  • Restore and cloning Postgres clusters on PVC, AWS, GCS and Azure
  • Additionally logical backups to S3 or GCS bucket can be configured
  • Standby cluster
  • Configurable for non-cloud environments
  • Basic credential and user management on K8s, eases application deployments
  • Support for custom TLS certificates
  • UI to create and edit Postgres cluster manifests
  • Support for AWS EBS gp2 to gp3 migration, supporting iops and throughput configuration
  • Compatible with OpenShift

PostgreSQL features

The Postgres Operator has been developed at Zalando and is being used in production for over five years.

Supported Postgres & K8s versions

Release Postgres versions pgBackRest versions Patroni versions K8s versions Golang
latest 13 → 16 2.51 3.2.2 1.21+ 1.19.8
next rc 13 → 16 2.51 3.2.2 1.21+ 1.22.1
  • Integrated backup solution, automatic backups and very easy restore (snapshot & PITR)
  • Rolling update procedure for adjustments to the pods and minor updates
  • Major upgrade with minimum interruption time
  • Reduction of downtime thanks to redundancy, pod anti-affinity, auto-failover and self-healing
  • Supports PostgreSQL 16, starting from 13+
  • Streaming replication cluster via Patroni
  • Point-In-Time-Recovery with pg_basebackup / pgBackRest via CYBERTEC-pg-container pg_stat_statements,
  • Incl. popular Postgres extensions such as pg_cron, pg_partman, postgis, set_user and timescaledb credcheck

Getting started

Getting started - Documentation

Tutorials.

Documentation

There is a browser-friendly version of this documentation at CPO-Documentation

Community

Coming soon