Revision 363

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

• PostgreSQL upgrade 14.9 -> 14.10. (DPE-3217 )

  • Note: It is advisable to REINDEX potentially-affected indexes after installing this update! (See PostgreSQL changelog )

• Added COS Awesome Alert rules (DPE-3160 )

• Updated TLS libraries for compatibility with new charms

  • manual-tls-certificates

  • self-signed-certificates

  • Any charms compatible with tls_certificates_interface.v2.tls_certificates

Minor features

• [CORE] Juju 3.1.7+ support (#2037120 )

• [PLUGINS] pgVector extension/plugin (DPE-3159 )

• [PLUGINS] New PostGIS plugin ( #312 )

• [PLUGINS] More new plugins - 50 in total

Bug fixes

• DPE-3199 Stabilized internal Juju secrets management

• DPE-3258 Check system identifier in stanza (backups setup stabilization)

Full Changelog: https://github.com/canonical/postgresql-operator/compare/rev351…rev363

Packaging

• Charmed PostgreSQL ships the latest PostgreSQL 14.10-0ubuntu0.22.04.1

• PostgreSQL cluster manager Patroni updated to v.3.1.2

• Backup tools pgBackRest updated to v.2.48

• The Prometheus postgres-exporter is 0.12.1-0ubuntu0.22.04.1~ppa1

• VM charms based on Charmed PostgreSQL SNAP (Ubuntu LTS 22.04 - ubuntu:22.04-based) revision 96

• Principal charms supports the latest LTS series 22.04 only

• Subordinate charms support LTS 22.04 and 20.04 only

Requirements

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

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