Revision 158

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

Features you can start using today

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

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

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

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

• PostgreSQL plugins support [DPE-1372]

• Profiles configuration support [DPE-2656]

• Logs rotation [DPE-1755]

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

  • Contacts

• 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.
Highlights for the current revision:

• DPE-1470, DPE-2419 Fixed K8s resources cleanup

• DPE-1584 Backup/restore stabilization bug fixes

• DPE-2546 Split stanza create and stanza check (backup stabilization)

• DPE-2626, DPE-2627 Create bucket once and clear up blocked statuses (backup stabilization)

• DPE-2657 Fix replication after restore

• DPE-1590 Fixed deployment on old microk8s (e.g. 1.22)

• DPE-2193 Fixed databases access to requested db only

• DPE-1999 Fixed TLS race condition in new relations (stuck in ‘awaiting for cluster to start’/’awaiting for member to start’)

• DPE-2338 Use SCRAM by default

• DPE-2616 Auto-tune profile production (mimic defaults of the legacy charm)

• DPE-2569 Set waiting status while extensions are being enabled

• DPE-2015, DPE-2044 Add missing zone info

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

Inside the charms

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

• K8s charms based on our ROCK OCI (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.

Technical notes

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

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