☁️ Postgres operator creates and manages PostgreSQL clusters running in Kubernetes https://postgres-operator.readthedocs.io/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
Jairo Llopis 720b4575c7
docs: fix broken links (#1594)
6 days ago
.github update Go and dependencies (#1645) 1 week ago
charts import PodToleration from opConfig to internal config (#1647) 1 week ago
cmd Introduce ENABLE_JSON_LOGGING env variable (#1158) 1 year ago
docker Fix logical backup script sigpipe problem (#1623) 3 weeks ago
docs docs: fix broken links (#1594) 6 days ago
e2e e2e: wait for replica after failover before fetching leader (#1649) 1 week ago
hack hack: update shebang (#755) 1 year ago
kubectl-pg update Go and dependencies (#1645) 1 week ago
manifests import PodToleration from opConfig to internal config (#1647) 1 week ago
mocks Support EBS gp2 to gp3 migration on sync for below 1tb volumes (#1242) 10 months ago
pkg import PodToleration from opConfig to internal config (#1647) 1 week ago
ui make Postgres 14 available (#1636) 1 week ago
.flake8 Implement runner for e2e tests (#548) 2 years ago
.gitignore Support EBS gp2 to gp3 migration on sync for below 1tb volumes (#1242) 10 months ago
.golangci.yml add .golangci.yml (#422) 2 years ago
.zappr.yaml Min 2 zalando approvers. (#1338) 8 months ago
CODEOWNERS Initial commit for new 1.6 release with Postgres 13 support. (#1257) 10 months ago
CONTRIBUTING.md Update docs for v1.2 (#609) 2 years ago
LICENSE update year in generated code and maintainer info in Dockerfiles (#1298) 9 months ago
MAINTAINERS Initial commit for new 1.6 release with Postgres 13 support. (#1257) 10 months ago
Makefile update Go and dependencies (#1645) 1 week ago
README.md make Postgres 14 available (#1636) 1 week ago
SECURITY.md docs(general): Adding Security.md (#88) 4 years ago
build-ci.sh reflect change in github url (#496) 2 years ago
delivery.yaml update Go and dependencies (#1645) 1 week ago
go.mod update Go and dependencies (#1645) 1 week ago
go.sum update Go and dependencies (#1645) 1 week ago
mkdocs.yml Initial commit for new 1.6 release with Postgres 13 support. (#1257) 10 months ago
run_operator_locally.sh Add CRD validation (#599) 1 year ago

README.md

Postgres Operator

Tests E2E Tests Coverage Status

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 (AWS EBS, PVC)
  • Database connection pooling with PGBouncer
  • Support fast in place major version upgrade to PG13. Supports global upgrade of all clusters.
  • Restore and cloning Postgres clusters (incl. major version upgrade)
  • Additionally logical backups to S3 bucket can be configured
  • Standby cluster from S3 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
  • Works well on Amazon AWS, Google Cloud, OpenShift and locally on Kind
  • Support for AWS EBS gp2 to gp3 migration, supporting iops and throughput configuration

PostgreSQL features

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

Using Spilo 12 images or lower

If you are already using the Postgres operator in older version with a Spilo 12 Docker image you need to be aware of the changes for the backup path. We introduce the major version into the backup path to smoothen the major version upgrade that is now supported.

The new operator configuration can set a compatibility flag enable_spilo_wal_path_compat to make Spilo look for wal segments in the current path but also old format paths. This comes at potential performance costs and should be disabled after a few days.

The newest Spilo image is: registry.opensource.zalan.do/acid/spilo-14:2.1-p2

The last Spilo 12 image is: registry.opensource.zalan.do/acid/spilo-12:1.6-p5

Getting started

For a quick first impression follow the instructions of this tutorial.

Supported setups of Postgres and Applications

Features

Documentation

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

Community

There are two places to get in touch with the community:

  1. The GitHub issue tracker
  2. The #postgres-operator slack channel