Revisions 552, 553

A new revision of Charmed PostgreSQL for machines has been published in the 14/stable channel.

Charmhub • System requirements • How to deploy • How to upgrade • All release notes

What’s changed

This section outlines the most important highlights, features and bug fixes in this release.

Highlights

• Upgraded PostgreSQL from v.14.12 → v.14.15 ( #730 )

  • Check the official PostgreSQL 14.13 release notes

  • Check the official PostgreSQL 14.14 release notes

  • Check the official PostgreSQL 14.15 release notes

• Added timeline management to point-in-time recovery (PITR) ( #629 ) (DPE-5561 )

• Added pgAudit plugin/extension ( #612 ) (DPE-5248 )

• Observability stack (COS) improvements

  • Polished built-in Grafana dashboard ( #646 )

  • Improved COS alert rule descriptions ( #651 ) (DPE-5658 )

• Added fully-featured terraform module ( #643 )

Minor features

• Several S3 stability improvements ( #642 )

• Removed patching of private ops class. ( #617 )

• Switched charm libs from tempo_k8s to tempo_coordinator_k8s and relay tracing traffic through grafana-agent ( #640 )

• Implemented more meaningful group naming for multi-group tests ( #625 )

• Ignoring alias error in case alias is already existing ( #637 )

• Stopped tracking channel for held snaps ( #638 )

• Added pgBackRest logrotate configuration ( #645 ) (DPE-5601 )

• Grant privileges to non-public schemas ( #647 ) (DPE-5387 )

• Added tls and tls-ca fields to databag ( #666 )

• Merged update_tls_flag into update_endpoints ( #669 )

• Made tox commands resilient to white-space paths ( #678 ) (DPE-6042 )

• Added microceph (local backup) integration test + bump snap version ( #633 ) (DPE-5386 )

• Add max_locks_per_transaction config option in #718 (DPE-5533 )

• Split PITR backup test in AWS and GCP ( #605 ) (DPE-5181 )

Bug fixes

• Juju secrets resetting fix on Juju 3.6 in ( #726 ) (DPE-6320 ) (DPE-6325 )

• Fallback to trying to create bucket without LocationConstraint in ( #690 )

• Added warning logs to Patroni reinitialisation ( #660 )

• Fixed some postgresql.conf parameters for hardening ( #621 ) (DPE-5512 )

• Fixed lib check ( #627 )

• Allow --restore-to-time=latest without a backup-id in ( #683 )

• Clean-up duplicated Patroni config reloads in ( #682 )

• Filter out degraded read only endpoints in ( #679 ) (DPE-5714 )

• remove clutter from singlestat panels in cos ( #702 )

• Catch wrong parameters exception on bucket create function call ( #701 ) (DPE-5713 )

• Split topology script ( #729 ) (DPE-6377 )

• Fix typos in COS alert rules ( #724 ) (DPE-6171 )

• Add plugins preload libs to regular startup parameters ( #741 ) (DPE-6056 )

Full Changelog: https://github.com/canonical/postgresql-operator/compare/rev467…rev552

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.3.

The recommended Juju version for this charm is v3.6.1+.

See the system requirements for more details about Juju versions and other software and hardware prerequisites.