Revisions 843, 844

The first stable revision of Charmed PostgreSQL 16 for VM has been released in the 16/stable channel. Besides a major workload upgrade from PostgreSQL 14.15 to 16.9, this release comes with several new features and improvements.

Thank you to everybody who helped make this release happen!

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

Features

• Workload upgrade from PostgreSQL 14 to 16

  • [DPE-5833] New PostgreSQL 16 charm by @lucasgameiroborges in #680

    • [DPE-5833] Update Charmed Postgresql snap to 16.9 by @dragomirp in #791

• [DPE-6965] Juju storage pools for flexible storage configuration options by @marceloneppel in #852

  • See: How to deploy on Juju storage

• [DPE-6904] Enhanced networking capabilities for complex deployment scenarios with Juju spaces by @paulomach in #857

  • See: How to deploy on Juju spaces

• [DPE-6189] Password management with Juju user secrets by @reneradoi in #833

  • See: How to manage passwords

• New in-place upgrades & rollbacks using fresh refresh v3 library by @carlcsaposs-canonical in #866

• [DPE-7309][DPE-7326] Switch to TLS v4 library by @dragomirp in #909 * New endpoints client-certificates and peer-certificates * Endpoint peer-interfaces uses TLS by default * See all endpoints on Charmhub

• Several improvements to built-in roles * [DPE-7499] Remove admin and postgres roles by @marceloneppel in #931 * Predefined roles compatibility by @marceloneppel in #960

  • [DPE-7498] Create new DB charmed_* roles by @marceloneppel in #932

  • See Roles

• New documentation site - versioned on GitHub with search functionality and dark mode

• [DPE-6678] PostgreSQL config improvement by @Pepsiqqq in #778

• [DPE-7614] Remove replica re-initialisations by @dragomirp in #999

• [DPE-7549] Speed up backups restore by @dragomirp in #983

• Speed up (parallel) patroni calls by @dragomirp in #925

• [DPE-6555] Add read only URIs to data-integrator by @dragomirp in #783

• Protect the default scope in promote action by @dragomirp in #855

• [DPE-7691] Migrate snap from snap_daemon to daemon (584792) by @taurus-forever in #1024

• Update dependency cryptography to v44.0.1 [SECURITY] by @renovate[bot] in #764

Breaking changes

• Deprecated legacy interface psql - Endpoints db and db-admin are no longer supported

  • See: Interfaces and endpoints

• Support for Juju < v3.6 removed

  • Charmed PostgreSQL 16 requires Juju 3.6+ LTS due to Juju secrets support

• Juju actions get-password and set-password removed

  • Replaced by Juju secrets for enhanced security

• Timescale Apache 2 edition replaced by Timescale Community edition

• Charm action set-tls-private-key removed

  • Will be re-introduced as Juju user secrets in future releases

• Charm actions renamed for consistency with juju refresh terminology

  • pre-upgrade-check → pre-refresh-check

  • resume-upgrade → resume-refresh

• **Charm endpoint certificates split into separate endpoints

  • client-certificates - For client certificate management

  • peer-certificates - For peer-to-peer certificate management

Bug fixes

• [DPE-7678] Enable disable extensions after restore by @dragomirp in #1025

• [DPE-6815] Disable pgaudit during extensions changes by @dragomirp in #840

• [DPE-6662] Fix pgbackrest logs names on logs rotation by @taurus-forever in #939

• [DPE-6323] Handle missing stanza output by @dragomirp in #727

• [DPE-7614] Don’t restart during initial sync by @dragomirp in #994

• Update charm-refresh to v3.0.0.3 by @carlcsaposs-canonical in #1008

• [DPE-7678] Recreate predefined roles by @dragomirp in #1017

• Use test app beta for isolated test by @dragomirp in #1032

• Fix charm refresh compatibility version tag during build by @carlcsaposs-canonical in #892

• Update charm-refresh-build-version to fix charm refresh version by @carlcsaposs-canonical in #894

Compatibility

Charmed PostgreSQL 16 is built for Noble (Ubuntu 24.04), and supports arm64 and amd64.

Charmhub revision (amd, arm)	Snap revision (amd, arm)	PostgreSQL version	Minimum Juju version*
843, 844	218, 219	16.9	3.6

* We recommend always using the latest Juju LTE version when possible.

Upgrading from 14 to 16

We currently do not support in-place upgrades from PostgreSQL 14 to 16, but we are developing a guide with instructions on how to perform this upgrade manually.

In the meantime, contact us if you have any questions or support needs.

New contributors

We have 15 new contributors to Charmed PostgreSQL codebase! :trophy:

• @paulomach made their first contribution in #13

• @rwcarlsen made their first contribution in #29

• @carlcsaposs-canonical made their first contribution in #69

• @deusebio made their first contribution in #84

• @TakoB222 made their first contribution in #251

• @juditnovak made their first contribution in #307

• @tonyandrewmeyer made their first contribution in #322

• @Zvirovyi made their first contribution in #323

• @lucasgameiroborges made their first contribution in #425

• @BalabaDmitri made their first contribution in #396

• @BON4 made their first contribution in #454

• @shayancanonical made their first contribution in #485

• @hloeung made their first contribution in #690

• @Pepsiqqq made their first contribution in #778

• @reneradoi made their first contribution in #833

Full Changelog: https://github.com/canonical/postgresql-operator/commits/v16/1.59.0