Revisions 552, 553¶

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

What’s changed¶

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

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)

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)

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

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.