Revision 158

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

See: How to perform an upgrade

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
  • Development
  • Testing reference
  • Legacy charm
  • Plugins/extensions, supported
  • Juju 2.x vs 3.x hints
  • Contacts
• All the functionality from the previous revisions

Bugfixes

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

• DPE-1470, DPE-2419 Fixed K8s resources cleanup
• DPE-1584 Backup/restore stabilization bugfixes
• 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 zoneinfo

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