We are excited to announce a new release of the Postgres Operator. Thanks to everyone who contributed with PRs, feedback, raising issues or providing ideas.

New features

• Individual environment variables per cluster (#1794, #1848)
• Support standby clusters from remote primary and GCS WAL backup location (#1544, #1446)
• Optional user and password rotation inside K8s secrets (#1749, #1796)
• Operator can create CRDs for streaming change data capture into Nakadi (#1570)
• Define extra roles granted to database owners (e.g. cron_admin) (#1805)
• Define annotations to be ignored on sync (#1823, #1485, #1482)
• Enable auto major version upgrade only for clusters of specified teams (#1699)
• Support for Patroni's synchronous_node_count option (#1484)
• [UI] added IOPS and throughput options for volume settings (useful for AWS gp3 volumes) (#1824)
• [Logical-Backup] Introduce configurable retention time for logical backups on S3 (#1337)

Enhancements

• Choose switchover target based on lag and role (#1700, #1724)
• Added ReadinessProbe on the stateful set (#1825)
• Pooler services can now be turned into type LoadBalancer, too (#943, #1799)
• Toleration changes will now be reflected on cluster sync (#1729)
• Node readiness label can now be evaluated together with specfied nodeAffinities (#1729)
• Major version upgrades can be executed by rootless user (#1770)
• Inherited labels and annotations are passed to PVCs, too (#1784)
• CRD registration by the operator can now be skipped (#1733)
• Empty resources in manifest will now pass validation with go-client (#1589, #1822)
• Removed required fields of cluster resources from CRD schema. (#1822)
• Removed required fields of tolerations from CRD schema (#1797)
• Improve comparison of container ports on sync (#1755)
• Retry and timeout options for Patroni API calls (#1803)
• Adding retry logic when fetching the pod_environment_secret (#1777)
• Categories in CRDs are now configurable (#1781)
• Manifest example for minimal master/replica ServiceMonitor (#1452)
• Added doc chapter about restoring a cluster in place (#1833)
• move from Go 1.16.9 to 1.17.4 + updating dependencies (#1717)
• [pooler] bump to pgBouncer 1.17.0 and allow for scram secrets (#1837)
• [UI] postgres version and cluster resources can be changed in edit mode (#1824)
• [UI] ingresClassName option in helm chart (#1787)
• [Logical-Backup] Added IPv6 support for dump script (#1405)
• [helm] Added user-facing cluster roles (#1675)

Fixes

• Replace instances on rolling update only when all instances are healthy (#1767)
• Make sure major version upgrade script runs on the master (#1715)
• When kubernetes_use_configmaps is true, do not try to create endpoints (#1760)
• Fixed nil pointer while syncing pooler deployment (#1701)
• Skip EBS migration when no volumes are found to not block cluster from healing itself (#1851)
• Return only a warning instead of error if teams API returns a 404 Not Found (#1842)
• Removed CRD validation toggle from go code to avoid errors when operator registers CRDs (#1697)
• Code generation uses correct target folder again (#1713)
• [UI] fix fetching logs when teamId contains hyphens (#1859)

Breaking changes

• variables from pod_environment_secret take precedence over pod_environment_configmap (#1848)
• deprecated CRD validation toggle because schema must be present in apiextensions.k8s.io/v1 (#1781)
• dropped support for helm2 charts (#1679)
• dropped v1.5.0.tgz from helm chart folders (#1852)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.8.0 UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.8.0 Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.8.0 Default Spilo image: registry.opensource.zalan.do/acid/spilo-14:2.1-p5

Thanks to our contributors: @FxKu, @jopadi, @sdudoladov, @Jan-M, @CyberDem0n, @dmvolod, @machine424, @evsasha, @uzzz, @neelasha-09, @dpeckett, @Menzorg, @stoewer, @jamesmcdonald, @Cellebyte, @jgillich, @preved911, @snarlysodboxer, @ermajn, @Prototik, @moshloop, @spohner, @OlleLarsson, @Aisuko, @Lxrdknows77, @Wikiwix, @Mattes83, @mujx, @RafiaSabih, @ebostijancic, @bleleve, @apeschel, @sdressler, @kien-truong