We are very excited to announce a new release of the Postgres Operator in 2020! :christmas_tree: :elephant: This is the first release using the Spilo 13 image, incl. Patroni v2.0 and the newest PostgreSQL. Please, read about the breaking changes when switching to PG13. Update your CRDs to have manifest validation and field presevation up-to-date for newer Kubernetes versions (1.19+).

New features

• In-place major version upgrade (#1160, https://github.com/zalando/spilo/pull/488)
• NodeAffinity support (#1166, #1263)
• pgBouncer support for replicas (#1159)
• PostgresTeam CRD to define custom team mappings (#1165)
• Specify alternative scheduler (#1226)
• Inherited annotations for all major objects (#1236)
• Delete protection for Postgres manifests via annotations (#1069)
• Allow pod environment variables to be sourced from a secret (#946, #1177)
• Support wal-e backups to GCS (#620)
• Support migration to AWS gp3 volumes (#1242)
• Enable JSON logging (#1158)

Enhancements and fixes

• New storage_resize_mode option to resize volumes via updating PVCs (#958)
• ExternalTrafficPolicy of services can now be configured (#1136)
• Extend logical backup support to GCS (#1173)
• Set search_path for default roles in PreparedDatabases (#1065)
• Support scram-sha-256 hash for password encryption (#995)
• Include diffs on securityContext when clusters are synced (#1007, #1255)
• Deletion of secrets on cluster deletion (#974, #1054, #1091)
• More flexibility when referencing an existing infrastructure roles secret (#1064, #1090)
• Improved visibility of events on failed cluster setups (#1013)
• Fixes and improvements on pgBouncer support (#960, #1169, #1171, #1213)
• Fixed configuring CRD via go-client (#1020, #1223)
• Fixed case where no NodeReadinessLabel is defined, but node is unscheduable (#1162)
• Fixed changing order of sidecar env variables (#980)
• Fixed syncing PreparedSchemas (#1139)
• Fixed cloning from GCS (#1176)
• Make setup on OpenShift easier when using helm charts (#1037)
• Increase speed of e2e test and update kind version (#1180, #1185, #1121, #1156)
• UI: Now display cluster status if setup failed (#1260)
• UI: Add support for custom S3 endpoints (#1152)
• UI: Add imagePullSecret to deployment in helm chart (#1211)
• UI: Add Kustomization manifest (#1086)

Breaking changes

• Manifest entries for pg_hba will overwrite the configuration and not append to it!
• Variables in pod environment config map / secret will overwrite AWS/GCP setting in operator config (#1177)
• Enable PGVERSION env variable for Postgres 13 image (#1172, #1160, #1254, #1260)
• Change default volume resize strategy to update PVCs instead of AWS API call (#1257)
• Migrate CRDs to apiVersion v1 (#746, #1212, #1228, #1248)
• Make volume section in Postgres manifest a required field (#1016)
• Update to Go 1.15 (#1122, #1242)
• Switch public builds from Travis to GitHub Actions (#1215)

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

Many thanks to the committers @Jan-M, @FxKu, @erthalion, @RafiaSabih, @sdudoladov special thanks to @CyberDem0n for his continuous work on Patroni and Spilo, and a loud applause to our external contributors @yanchenko-igor, @sagor999 @Frittentheke, @Thunderbolt32, @spohner, @neelasha-09, @hlihhovac, @alfredw33, @arminfelder, @bbsbb, @lxgege, @preved911, @dajudge, @lalbers, @hoangelos, @programmer04, @Gottox, @mcoletti, @arichardet, @sonaysevik, @dalbani, @abh, @SanjeevChoubey, @toonsevrin, @kupson