Reference > Release Notes > All revisions > Revision 363

Revision 363

_{February 21, 2024}

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

• [CORE] PostgreSQL upgrade 14.9 → 14.10. (DPE-3217)
  • Note: It is advisable to REINDEX potentially-affected indexes after installing this update! (See PostgreSQL changelog)
• [CORE] Juju 3.1.7+ support (#2037120)
• [PLUGINS] pgVector extension/plugin (DPE-3159)
• [PLUGINS] New PostGIS plugin (#312)
• [PLUGINS] More new plugins - 50 in total
• [MONITORING] COS Awesome Alert rules (DPE-3160)
• [SECURITY] Updated TLS libraries for compatibility with new charms
  • manual-tls-certificates
  • self-signed-certificates
  • Any charms compatible with tls_certificates_interface.v2.tls_certificates
• All functionality from previous revisions

Bugfixes

• DPE-3199 Stabilized internal Juju secrets management
• DPE-3258 Check system identifier in stanza (backups setup stabilization)

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.

What is inside the charms

• Charmed PostgreSQL ships the latest PostgreSQL 14.10-0ubuntu0.22.04.1
• PostgreSQL cluster manager Patroni updated to v.3.1.2
• Backup tools pgBackRest updated to v.2.48
• 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) revision 96
• Principal charms supports the latest LTS series 22.04 only
• Subordinate charms support LTS 22.04 and 20.04 only

Technical notes

• Starting with this revision (336+), you can use juju refresh to upgrade Charmed PostgreSQL
• Use this operator together with modern Charmed PgBouncer operator
• Please check 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.