Revision 193

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

Charmhub • System requirements • How to deploy • How to upgrade • All release notes

What’s changed

This section outlines the most important highlights, features and bug fixes in this release.

PostgreSQL has been upgraded from 14.9 to 14.10 (DPE-3217 )

[!NOTE]
It is advisable to re-index potentially affected indexes after installing this update! (See PostgreSQL14.10 changelog )

Features

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

Bug fixes

• Stabilized internal Juju secrets management (DPE-3199 | #358 )

• Check system identifier in stanza (backups setup stabilization) (DPE-3061 )

Full Changelog: https://github.com/canonical/postgresql-k8s-operator/compare/rev177…rev193

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.