We are excited to announce yet another release of the Postgres Operator. It's a big one! :elephant:

New features

• Database-side connection pooling with pgBouncer (#799, #883, #906)
• Global sidecars supporting full container spec (#890)
• Specify additional volumes per Postgres cluster manifest (#736, #933)
• Support for custom TLS certificates (#798, #920)
• Let operator create databases with pre-defined roles and privileges (#843)
• Add database schemas and extensions via manifest (#843)
• Additional synchronous replication modes available via Patroni (#869)
• Optional lazy update of spilo image to save up rolling updates for node rotations (#859)
• New option to propagate annotations from CRD to statefulset / deployment (#932)
• New ownership annotation to run multiple operators next to each other (#802)
• UI: Add toggle for connection pooler (#953)
• UI: Add option for NodePort services (#928)

Enhancements and fixes

• New Spilo image can run with a rootless user
• Better compatibility with OpenShift (#885, #887, #921)
• Emit K8s events to the Postgresql CR for better user feedback (#896, #952)
• Recreate pods only if all replicas are running (#903)
• Allow custom pod environment configmap in separate namespaces (#870)
• Use cryptographically secure password generation (#854)
• Changing the PostgreSQL version in the manifest is simply omitted (#860)
• Clearer logging when exceeding MasterPodMoveTimeout (#846)
• Make postgres-pod cluster role dynamic in helm chart (#802)
• UI: List individual S3 wal files in backups view (#880)

Breaking changes

• Update your postgres-operator cluster role (deployments and events added) (#799, #952)
• Passing ClusterLabels as JSON to Spilo (#877)
• Switching to Go 1.14 (#882)
• Scalyr sidecar deprecated (#945, #890)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.5.0 UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.5.0-dirty Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:master-58 Connection pooler image: registry.opensource.zalan.do/acid/pgbouncer:master-7

Shipped with latest Patroni v1.6.5 and Spilo 12:1.6-p3 releases

Many thanks to the committers @erthalion, @FxKu, @sdudoladov, @RafiaSabih, @Jan-M, special thanks to @CyberDem0n for his continuous work on Patroni and Spilo, and kudos to our external contributors @ReSearchITEng, @seuf, @zimbatm, @fischerman, @frittentheke, @lalbers, @Prototik, @siku4, @f2cognite, @PetrBarborka, @marcusportmann, @hengchu, @grantlanglois, @hzliangbin, Jonher937, @boopathykpm