Revision 351

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

• [Core] Updated Charmed PostgreSQL SNAP image ( #291 )(DPE-3039 ):

  • Patroni updated from 3.0.2 to 3.1.2

  • Pgbackrest updated from 2.47 to 2.48

• [Plugins] Add 24 new plugins/extension in ( #251 )

  • NOTE: extension plpython3u is deprecated and will be removed from list of supported plugins soon!

• [Config] Add 29 new configuration options in ( #239 )(DPE-1781 )

  • NOTE: the config option profile-limit-memory is deprecated. Use profile_limit_memory (to follow the naming conventions )! ( #306 )(DPE-3096 )

Minor features

• [Charm] Add Juju Secret labels in ( #270 )(DPE-2838 )

• [Charm] Update Python dependencies in ( #293 )

• [DB] Add handling of tables ownership in ( #298 )(DPE-2740 )

• (COS ) Moved Grafana dashboard legends to the bottom of the graph in ( #295 )(DPE-2622 )

• (COS ) Add Patroni COS support ( #261 )(DPE-1993 )

• [CI/CD] Charm migrated to GitHub Data reusable workflow in ( #263 )(DPE-2789 )

Bug fixes

• Fixed enabling extensions when new database is created ( #252 )(DPE-2569 )

• Block the charm if the legacy interface requests roles (DPE-3077 )

Canonical Data issues are now public on both Jira and GitHub platforms. GitHub Releases provide a detailed list of bug fixes, PRs, and commits for each revision.

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

Packaging

• Charmed PostgreSQL ships the latest PostgreSQL “14.9-0ubuntu0.22.04.1”

• PostgreSQL cluster manager Patroni updated to “3.2.1”

• Backup tools pgBackRest updated to “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 89

• 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.1.6+.

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