Reference > Release Notes > All revisions > Revision 193

Revision 193

_{March 13, 2024}

Dear community,

We’d like to announce that Canonical’s newest Charmed PostgreSQL operator for Kubernetes 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 PostgreSQL14.10 changelog)
• [CORE] Juju 3.1.7+ support (#2037120)
• [PLUGINS] pgVector extension/plugin (DPE-3159)
• [PLUGINS] New PostGIS plugin (#363)
• [PLUGINS] More new plugins - 50 in total
• [MONITORING] COS Awesome Alert rules (DPE-3161)
• [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

• Stabilized internal Juju secrets management (DPE-3199 | #358)
• Check system identifier in stanza (backups setup stabilization) (DPE-3061)

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 PostgreSQL 14.10-0ubuntu0.22.04.1
• PostgreSQL cluster manager Patroni - v.3.1.2
• Backup tools pgBackRest - v.2.48
• The Prometheus postgres_exporter is 0.12.1-0ubuntu0.22.04.1~ppa1
• This charm uses ROCK OCI (postgresql-image resource-revision 149) based on SNAP revision 96
• This charm ships the latest base Ubuntu LTS 22.04.3

Technical notes

• Starting with this revision (193+), you can use juju refresh to upgrade Charmed PostgreSQL K8s
• It is recommended to use this operator together with modern Charmed PgBouncer operator
• Please check the external components requirements
• Please check 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.