Revision 177

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

See: How to perform an upgrade

What's changed

This section outlines the most important highlights, features and bugfixes in this release.

Updated Charmed PostgreSQL ROCK image in (PR#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 (PR#294)
• [Plugins] NOTE: extension plpython3u is deprecated and will be removed from list of supported plugins soon!
• [Config] Add 29 new configuration options in (PR#281)(DPE-1782)
• [Config] NOTE: the config option profile-limit-memory is deprecated. Use profile_limit_memory (to follow the naming conventions)! (PR#348)(DPE-3095)
• [Charm] Add Juju Secret labels in (PR#303)(DPE-2838)
• [Charm] Update Python dependencies in (PR#315)(PR#318)
• [DB] Add handling of tables ownership in (PR#334)(DPE-2740)
• [COS] Moved Grafana dashboard legends to the bottom of the graph in (PR#337)(DPE-2622)
• [CI/CD] Charm migrated to GitHub Data reusable workflow in (PR#338)(DPE-3064)
• All the functionality from the previous revisions

Bugfixes

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

• Fixed handle scaling to zero units in (PR#331)(DPE-2728)
• Fixed plugins enabling performance by toggling all plugins in one go (PR#322)(DPE-2903)
• Fixed enabling extensions when new database is created in (PR#290)(DPE-2569)
• Fixed locales availability in ROCK (PR#291)

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