Revisions 552, 553

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

See also: Releases overview page, How to perform an upgrade

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 (PR #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) (PR #629) (DPE-5561)
• Added pgAudit plugin/extension (PR #612) (DPE-5248)
• Observability stack (COS) improvements
  • Polished built-in Grafana dashboard (PR #646)
  • Improved COS alert rule descriptions (PR #651) (DPE-5658)
• Added fully-featured terraform module (PR #643)

Minor features

• Several S3 stability improvements (PR #642)
• Removed patching of private ops class. (PR #617)
• Switched charm libs from tempo_k8s to tempo_coordinator_k8s and relay tracing traffic through grafana-agent (PR #640)
• Implemented more meaningful group naming for multi-group tests (PR #625)
• Ignoring alias error in case alias is already existing (PR #637)
• Stopped tracking channel for held snaps (PR #638)
• Added pgBackRest logrotate configuration (PR #645) (DPE-5601)
• Grant priviledges to non-public schemas (PR #647) (DPE-5387)
• Added tls and tls-ca fields to databag (PR #666)
• Merged update_tls_flag into update_endpoints (PR #669)
• Made tox commands resilient to white-space paths (PR #678) (DPE-6042)
• Added microceph (local backup) integration test + bump snap version (PR #633) (DPE-5386)
• Add max_locks_per_transaction config option in (PR#718) (DPE-5533)
• Split PITR backup test in AWS and GCP (PR #605) (DPE-5181)

Bug fixes

• Juju secrets resetting fix on Juju 3.6 in (PR#726) (DPE-6320) (DPE-6325)
• Fallback to trying to create bucket without LocationConstraint in (PR#690)
• Added warning logs to Patroni reinitialisation (PR #660)
• Fixed some postgresql.conf parameters for hardening (PR #621) (DPE-5512)
• Fixed lib check (PR #627)
• Allow --restore-to-time=latest without a backup-id in (PR#683)
• Clean-up duplicated Patroni config reloads in (PR#682)
• Filter out degraded read only endpoints in (PR#679) (DPE-5714)
• remove clutter from singlestat panels in cos (PR#702)
• Catch wrong parameters exception on bucket create function call (PR#701) (DPE-5713)
• Split topology script (PR#729) (DPE-6377)
• Fix typos in COS alert rules (PR#724) (DPE-6171)
• Add plugins preload libs to regular startup parameters (PR#741) (DPE-6056)

Full Changelog: 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.