Charmed PostgreSQL revision 336

_{Wednesday, October 18, 2023}

Dear community, this is to inform you that new Canonical Charmed PostgreSQL is published in 14/stable charmhub channel for IAAS/VM.

The 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 included:

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

• 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

What is 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.

How to reach us:

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report.
Contribute to the project!

Hints:

Please check all the previous release notes if you are jumping over the several stable revisions!