Reference > Release Notes > All revisions > Revision 336

Revision 336

_{Wednesday, October 18, 2023}

Dear community,

We’d like to announce that Canonical’s newest Charmed PostgreSQL operator for IAAS/VM has been published in the 14/stable channel.

If you are jumping over several stable revisions, make sure to check previous release notes before upgrading to this revision.

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

Bugfixes

• 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] Copy fixes of DPE-2626 and DPE-2627 from k8s
• [MISC] Don’t fail if the unit is already missing
• [MISC] More resilient topology observer

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

GitHub Releases provide a detailed list of bugfixes, PRs, and commits for each revision.

Inside the charms

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

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

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.