Elated Barracuda

We are happy to announce yet another release of the Postgres Operator 🐘
We have also updated the UI and improved its setup and documentation to make local testing easier:

New features

• New cluster manifest option to specify custom service annotations (#803)
• New options to configure minimum CPU and memory limits (#808)
• Added service example for exposing operator REST API (#794)
• Logical Backup: New option logical_backup_s3_region (#813)
• UI: New column to show monthly cloud costs per cluster (can be configured) (#796)
• UI: Cluster name label is now configurable (cluster-name by default) (#796)
• UI: Added helm chart for the Postgres Operator UI (special thanks to @siku4) (#795)

Enhancements and fixes

• Bump Spilo version with latest minors of all supported PostgreSQL versions (#836)
• Update services when their annotations have changed (#818)
• Toggling load balancer services now only patches/updates the resource (#818)
• Standby clusters can have one instance (recommended) even if min_instances is set higher (#797, #842)
• Fixed unmarshalling of MasterPodMoveTimeout (#816)
• Change error computation on JSON unmarshal accross different Go versions (#801)
• Logical Backup: Reduce tracing of dumps and include postgresql-client-12 (#813)
• UI: Now works with stateful sets from K8s 1.16+ (#675)
• UI: Reordered columns and additional status step for cluster manifest (#796)
• UI: Updated dependencies (#796, #835)
• UI: Align build tag with operator (#844)
• UI: Improved documentation (#796)

Breaking changes

• The operator will now enforce minimum CPU and memory limits if specified below configured minimum (#808)
• New default cluster role postgres-pod dedicated for database pods and Patroni (#832)
• Switch rbac.authorization.k8s.io to v1. Update pod_service_account_role_binding_definition configuration if you are using it. (#829)
• Use cluster-name as default for cluster name label everywhere (#782)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.4.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.4.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup

Shipped with Patroni v1.6.4 and Spilo 1.6-p2

Many thanks to the committers @FxKu, @Jan-M, @erthalion, @RafiaSabih, @sdudoladov, @hjacobs,
special thanks to @CyberDem0n for his continuous work on Patroni and Spilo,
and applause to our contributors @jonathanbeber, @siku4, @vitobotta, @f2cognite

Zealous Raccoon

This is new minor release which simply bumps the version, as the v1.3.0 did not reflect the latest state from master. Copyright and licence are updated to 2020.

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.3.1
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:master-57
The Postgres Operator UI image remains unchanged.

Zealous Raccoon

Ho Ho Ho. We are happy to announce a new release of the Postgres Operator 🎄 🐘

New features

• Added validation and additionalPrinterColumns for CRDs (#599, #653)
• IPv6 support for Patroni URLs in database pods (#671)
• New option to define custom annotations for database pods (helps when running Istio) (#657)
• Additional options for logical backups to better support S3-compatible endpoints (#628)
• Creation of InitContainers and Sidecars can be disabled (#478)

Enhancements and fixes

• Move to StatefulSet api version apps/v1 (#675)
• Avoid orphaned objects when deleting cluster during creation (#654)
• Avoid errors when changing the service type (#716)
• Avoid stale cache when checking RBAC in namespaces (#685)
• Support any cluster name label in logical backup pod/dump script (#725)
• Improve documentation (#762)
• Compatibility with Helm v3 (#738)
• Switched dependency management from glide to go modules (#544)

Breaking changes

• Enforce minimum CPU and memory limits (#731)
• Remove clusterrole privilege from RBAC manifest (#765)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.3.0-dirty
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup
The Postgres Operator UI image remains unchanged.

Many thanks to the committers @FxKu, @sdudoladov, @erthalion, @RafiaSabih, @Jan-M
special thanks to @CyberDem0n for his continuous work on Patroni and Spilo.
and our contributors @optix2000, @ermajn, @runyontr, @zimbatm, @hasegeli, @brunsgaard,
@rektide, @deitmerit, @fwagner-smf, @IlyaSemenov, @bchrobot, @OlleLarsson @knan-nrk,
@anikin-aa, @haf-afa, @phobot, @AmirAliSobhGol, @yujunz, @EricLemieux, @CarlQLange

Jaunty Ocelot

We are happy to annouce a new release of the Postgres Operator:

New features:

• New browser-based UI to manage Postgres clusters (special thanks to @mgomezch) (#613)
• Operator can create cron jobs for logical backups (#442)
• Initialize standby cluster from WAL archive in S3 bucket (#562)
• Provide manifests for user-facing clusterroles (#585)
• New end-2-end test suite using kind (#548)
• New deployment options: Helm chart (#434), Kustomization (#608) and OLM

Enhancements and fixes:

• Added non-privileged option for Spilo (#525)
• Run operator pod as non-root (#582)
• New SpiloFSGroup parameter to allow non-root Spilo (#531)
• Support Pod Anti Affinity (#489)
• Support podManagementPolicy in Spilo StatefulSets (#515)
• Fix updating initContainers (#518)
• Cloning cluster from an arbitraty bucket (#487)
• Additional S3 settings to support cloning in non AWS environments (#497)
• Additional secret mount to support credentials provisioning in non-cloud K8s environments (#535)
• Support SubPath for Postgres container volumes (#452)
• Config option to relax PodDisruptionBudget (#384, #583)
• Allow non-default cluster domains (#561)
• Align ConfigMap and CRD-based configuration (#595)
• Extended and improved documentation (#609)

Breaking changes:

• CRD's /status subresource is now a struct instead of string field (#534)
• camelCasing manifest parameters initContainers and podPriorityClassName (#602)
• Changed repo org from github.com/zalando-incubator to github.com/zalando (#495, #496)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.2.0
UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.2.0
Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup

Many thanks to the committers @sdudoladov, @FxKu, @erthalion, @RafiaSabih, @Jan-M
and our contributors @mgomezch, @knan-nrk, @stang, @redbaron, @aaroniscode, @teutonet,
@yujunz, @kimxogus, @Shinzu, @kupson, @coderanger, @jakub-roman, @VineethReddy02, @hjacobs

Aerobic Parrot

Newest release of the postgres operator, includes among other things:

• support for setting shmem for better parallel query support
• fix issue surrounding delete cluster
• fix reporting .status
• support init containers
• improved logging in rolling upgrade
• added superuser team support (additional team to be created as superuser)
• support setting additional replication slots via Patroni

Thanks to everyone involved for reporting problems and contributing to the operator!

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.1.0

Initial release

Initial release after a year in development.

The operator manages creation and deletion of PostgreSQL clusters based on the Spilo docker image and updates the running clusters based on the changes in the Postgres cluster manifest. It supports Kubernetes 1.5+, and Kubernetes 1.9 is recommended to take advantage of all features (namely, pod priorities).

New versions will follow the semantic version, with the major part changing because of incompatible changes or if we drop support for older Kubernetes cluster versions.

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.0.0