Revision 177

A new revision of Charmed PostgreSQL for Kubernetes 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.

Updated Charmed PostgreSQL ROCK image in ( #336 )(DPE-3039 ):

• Patroni updated from 3.0.2 to 3.1.2

• Pgbackrest updated from 2.47 to 2.48

Features

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

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

• [Config] Add 29 new configuration options in ( #281 )(DPE-1782 )

• [Config] NOTE: the config option profile-limit-memory is deprecated. Use profile_limit_memory (to follow the naming conventions )! ( #348 )(DPE-3095 )

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

• [Charm] Update Python dependencies in ( #315 )( #318 )

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

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

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

• All the functionality from the previous revisions

Bug fixes

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

• Fixed handle scaling to zero units in ( #331 )(DPE-2728 )

• Fixed plugins enabling performance by toggling all plugins in one go ( #322 )(DPE-2903 )

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

• Fixed locales availability in ROCK ( #291 )

Full Changelog: https://github.com/canonical/postgresql-k8s-operator/compare/rev158…rev177

Inside the charms

• Charmed PostgreSQL K8s 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”

• K8s charms based on our ROCK OCI (Ubuntu LTS “22.04” - ubuntu:22.04-based) based on SNAP revision 89

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

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

Technical notes

• Upgrade (juju refresh) is possible from this revision 158+

• Use this operator together with a modern operator “pgBouncer K8s ”

• Please check the external components requirements

• Please check additionally the previously posted restrictions

• Ensure the charm requirements met

Contact us

Charmed PostgreSQL K8s 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.