Deliberate Dog

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

• Added support for Postgres 16 (#2437, #2557)
• ARM support for UI and logical backup images (#2426, #2527)
• New config option to prevent operator from removing PVCs on cluster deletion (#2579, #1074)
• New config option to specify PVC retention policy when deleting or scaling statefulset (#2343, #2415, #2420)
• Add support for hugepages-2Mi/-1Gi in resources section incl. sidecars (#2311, #2512)
• Finalizers can be enabled so custom resource in only removed after its child resources (#941, #2509, #2521, #2538)
• Support for dead letter queue to recover from failed events (#2421)
• Master label selector can be disabled for the cluster's PodDisruptionBudget (#2364)
• Single users can opt out from globally enabled password rotation (#2528)
• [LogicalBackup] Can specify extra environment variables in a logical_backup_cronjob_environment_secret (#2051)

Enhancements

• Allow empty resources when defaults are no set (#2524)
• Removal of standby section will promote the cluster (#2472, #2513)
• Support switching secret rotation mode to in-place directly (#2549)
• Reduced number of calls on transitive team mappings (#2445)
• Configurable priority class for helm chart (#2499)
• Double check current Postgres version before trying upgrade (#2533)
• Inherited labels and annotations are also passed to logical backup pod (#2456)
• Improve appearance of Readme image in github dark mode (#2431)
• Improve docs on prepared users (#2424, #2425)
• Improve docs structure on cluster configuration (#2504)
• Logging of all returned errors on closing database connections (#2578)
• Use Alpine 3 base image without minor version (#2488)
• Added unit test for cluster Create() method (#2509)
• Replaced deperecated ioutil package (#2480, #2531)
• Bumped the pgBouncer version in pooler image to 1.22.0 (#2529)
• Go to 1.21 and updated depedencies (#2554, #2577, #2676, #2443, #2433, #2501, #2442)
• Add OCI label for container image source (#2541)
• [UI] Improve docs on watched namespaces (#2412)
• [LogicalBackup] Bump Ubuntu version (#2478)

Bugfixes

• Operator reflects new member states returned by Patroni cluster endpoint (#2515)
• Avoid password replacement if system users for pooler or streams are listed in the manifest (#2489)
• Compare single volume templates only if the number of templates has not changed (#2493)
• Changes to synchronous node count in Patroni section are now diffed (#2558)
• Update internal PostgresSpec after updating cluster status to not block subsequent updates (#2546)

Breaking changes

• Operator will not set the users section in Patroni config anymore (was not utilized anyway) (#2490)
• Dropped support for Postgres 10 (#2557)
• Dropped helm packages for 1.7.x releases (#2580)

Docker image: registry.opensource.zalan.do/acid/postgres-operator:v1.11.0 Multi-arch image (arm): ghcr.io/zalando/postgres-operator:v1.11.0 UI Docker image: registry.opensource.zalan.do/acid/postgres-operator-ui:v1.11.0 Sample logical backup image: registry.opensource.zalan.do/acid/logical-backup:v1.11.0 Default Spilo image: ghcr.io/zalando/spilo-16:3.2-p2

Thanks to our contributors: @FxKu, @idanovinda, @Jan-M, @jopadi, @hughcapet, @sdudoladov, @macedigital, @silenium-dev, @frittentheke, @b1zzu, @stgrace, @bootc, @cstohr1, @seekingua, @andrejshapal, @urashidmalik, @capuche2412, @urashidmalik, @senthilnathan, @dgiebert, @tm604, @testwill, @dmotte, @Lukkie, @drivebyer, @sklirg, @ghost, @MisguidedEmails, @ErikLundJensen, @boomskats @spreeker, @regme