Charmed PostgreSQL VM

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 239 09 Feb 2022
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 226 01 Apr 2021
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable 430 28 Jun 2024
Ubuntu 22.04
14/stable 429 28 Jun 2024
Ubuntu 22.04
14/candidate 429 26 Jun 2024
Ubuntu 22.04
14/candidate 430 26 Jun 2024
Ubuntu 22.04
14/beta 430 26 Jun 2024
Ubuntu 22.04
14/beta 429 26 Jun 2024
Ubuntu 22.04
14/edge 436 10 Jul 2024
Ubuntu 22.04
14/edge 435 10 Jul 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information


22.04 20.04 18.04 16.04 14.04

Reference > Release Notes > All revisions > Revision 429/430

Revision 429/430

June 28, 2024

Dear community,

We’d like to announce that Canonical’s newest Charmed PostgreSQL operator has been published in the 14/stable channel :tada: :

Revisions: 429 430

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


  • [DPE-3882] Speed up charm bootstrap 2-3 times in PR#413
  • [DPE-3544] Fixed large objects ownership in PR#349
  • [DPE-3257] Fixed network cut tests in PR#346
  • [DPE-3202] Architecture-specific snap revision in PR#345
  • [DPE-3380] Handle S3 relation in primary non-leader unit in PR#340
  • [DPE-3559] Stabilise restore cluster test in PR#351
  • [DPE-3591] Fixed shared buffers validation in PR#361
  • [DPE-4068] Finished test migration from unittest to pytest + reenable secrets PR#451
  • [DPE-4106] Test legacy and modern endpoints simultaneously in PR#396
  • [DPE-2674] Convert to pytest style testing instead of unit test in PR#425
  • [DPE-3895] Handle get patroni health exception in PR#421
  • [DPE-3593] Only check config values against the DB in on_config_changed in PR#395
  • [DPE-3422] Switch to self-signed certificates in PR#336
  • [DPE-4336] Reset active status when removing extensions dependency block in PR#467
  • [DPE-4416] Fixed secrets crash for “certificates-relation-changed” after the refresh in PR#475
  • [DPE-4416] Fetch charm libs to the latest LIBPATCH (dp-libs v36) in PR#475
  • [DPE-4412] Use TLS CA chain for backups in PR#484
  • [DPE-4032] Stop exposing passwords on postgresql SQL queries logging in PR#495
  • [DPE-4453] Fix scale up with S3 and TLS relations in PR#480
  • [DPE-4598] Handle upgrade of top of the stack Juju leader in PR#492
  • [DPE-4416] Update rolling-ops lib to version 0.7 in PR#478
  • [MISC] Suppress oversee users in standby clusters in PR#507
  • [MISC] Updated snap, charm libs and switch away from psycopg2-binary in PR#372
  • Added check for replicas encrypted connection in PR#437
  • Updated test_landscape_scalable_bundle_db test in PR#378

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 latest PostgreSQL 14.11-0ubuntu0.22.04.1
  • PostgreSQL cluster manager Patroni updated to 3.1.2
  • Backup tools pgBackRest updated to 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.4) revision 113
  • Principal charms supports the latest LTS series 22.04 only

Technical notes

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.