Repository files navigation

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

• Rolling updates on Postgres cluster changes, incl. quick minor version updates
• Live volume resize without pod restarts (AWS EBS, PVC)
• Database connection pooling with PGBouncer
• Support fast in place major version upgrade. Supports global upgrade of all clusters.
• Pod protection during boostrap phase and configurable maintenance windows
• Restore and cloning Postgres clusters on AWS, GCS and Azure
• Additionally logical backups to S3 or GCS bucket can be configured
• Standby cluster from S3 or GCS WAL archive
• 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
• Compatible with OpenShift

• Supports PostgreSQL 17, starting from 13+
• Streaming replication cluster via Patroni
• Point-In-Time-Recovery withpg_basebackup /WAL-G orWAL-E viaSpilo
• Preload libraries:bg_mon,pg_stat_statements,pgextwlist,pg_auth_mon
• Incl. popular Postgres extensions such asdecoderbufs,hypopg,pg_cron,pg_repack,pg_partman,pg_stat_kcache,pg_audit,pgfaceting,pgq,pgvector,plpgsql_check,plproxy,postgis,roaringbitmap,set_user andtimescaledb

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

For a quick first impression follow the instructions of thistutorial.

There is a browser-friendly version of this documentation atpostgres-operator.readthedocs.io

• How it works
• Installation
• The Postgres experience on K8s
• The Postgres Operator UI
• DBA options - from RBAC to backup
• Build, debug and extend the operator
• Configuration options
• Postgres manifest reference
• Command-line options and environment variables