Revision 336

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

• Add Juju 3 support (Juju 2 is still supported) [DPE-1758 ]

• Charm minor upgrades and minor rollbacks [DPE-1767 ]

Other new features

• All secrets are now stored in Juju secrets [DPE-1758 ]

• Canonical Observability Stack (COS) support [DPE-1775 ]

• PostgreSQL plugins support [DPE-1373 ]

• Profiles configuration support [DPE-2655 ]

• Logs rotation [DPE-1754 ]

• Workload updated to PostgreSQL 14.9 [PR#18 ]

• Add ‘admin’ extra user role [DPE-2167 ]

• New charm ‘PostgreSQL Test App ’

• New documentation:

  • Architecture (HLD/LLD)

  • Upgrade section

  • Release Notes

  • Requirements

  • Profiles

  • Users

  • Logs

  • Statuses

  • Testing reference

  • Legacy charm

  • Plugins/extensions , supported

  • Juju 2.x vs 3.x

  • Contacts

Bug fixes

• DPE-1624 , DPE-1625 Backup/restore fixes

• DPE-1926 Remove fallback_application_name field from relation data

• DPE-1712 Enabled the user to fix network issues and rerun stanza related hooks

• DPE-2173 Fix allowed units relation data field

• DPE-2127 Fixed databases access

• DPE-2341 Populate extensions in unit databag

• DPE-2218 Update charm libs to get s3 relation fix

• DPE-1210 , DPE-2330 , DPE-2212 Open port (ability to expose charm)

• DPE-2614 Split stanza create and stanza check

• DPE-2721 Allow network access for pg_dump, pg_dumpall and pg_restore

• DPE-2717 Copy dashboard changes from K8s and use the correct topology dispatcher

• [MISC] More resilient topology observer

Canonical Data issues are now public on both Jira and GitHub platforms.

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

Technical notes

• juju refresh from the old-stable revision 288 to the current-revision 324 is NOT supported!!! The upgrade functionality is new and supported for revision 324+ only!

• Please check additionally the previously posted restrictions .

• Ensure the charm requirements met

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

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

Packaging

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

• PostgreSQL cluster manager Patroni updated to “3.0.2”

• Backup tools pgBackRest updated to “2.47”

• 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)

• Principal charms supports the latest LTS series “22.04” only.

• Subordinate charms support LTS “22.04” and “20.04” only.

Contact us

Charmed PostgreSQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

• Raise software issues or feature requests on GitHub

• Report security issues through Launchpad

• Contact the Canonical Data Platform team through our Matrix channel.