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 468 11 Sep 2024
Ubuntu 22.04
14/stable 467 11 Sep 2024
Ubuntu 22.04
14/candidate 529 29 Nov 2024
Ubuntu 22.04
14/candidate 528 29 Nov 2024
Ubuntu 22.04
14/beta 529 28 Nov 2024
Ubuntu 22.04
14/beta 528 28 Nov 2024
Ubuntu 22.04
14/edge 531 29 Nov 2024
Ubuntu 22.04
14/edge 530 29 Nov 2024
Ubuntu 22.04
16/edge 527 27 Nov 2024
Ubuntu 24.04
16/edge 526 27 Nov 2024
Ubuntu 24.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
24.04 22.04 20.04 18.04 16.04 14.04

Reference > Release Notes > All revisions > Revision 517/518

This page is a work in progress for a future release. Please revisit at a later date!

Revision 517/518

Canonical’s newest Charmed PostgreSQL operator has been published in the 14/stable channel.

Due to the newly added support for arm64 architecture, the PostgreSQL charm now releases multiple revisions simultaneously:

  • Revision is built for amd64 on Ubuntu 22.04 LTS
  • Revision is built for arm64 on Ubuntu 22.04 LTS

See also: How to perform a minor upgrade

Contents


Highlights

  • Added timeline management to point-in-time recovery (PITR) (PR #629) (DPE-5561)
  • Added pgAudit plugin/extension (PR #612) (DPE-5248)
  • Observability stack (COS) improvements
  • Added fully-featured terraform module (PR #643)
  • Several S3 improvements (PR #642)

Features and improvements

  • Split PITR backup test in AWS and GCP (PR #605) (DPE-5181)
  • Removed patching of private ops class. (PR #617)
  • Switched charm libs from tempo_k8s to tempo_coordinator_k8s and relay tracing traffic through grafana-agent (PR #640)
  • Implemented more meaningful group naming for multi-group tests (PR #625)
  • Ignoring alias error in case alias is already existing (PR #637)
  • Stopped tracking channel for held snaps (PR #638)
  • Added pgBackRest logrotate configuration (PR #645) (DPE-5601)
  • Grant priviledges to non-public schemas (PR #647) (DPE-5387)
  • Added tls and tls-ca fields to databag (PR #666)
  • Merged update_tls_flag into update_endpoints (PR #669)
  • Made tox commands resilient to white-space paths (PR #678) (DPE-6042)
  • Added microceph (local backup) integration test + bump snap version (PR #633) (DPE-5386)

Bugfixes and maintenance

  • Added warning logs to Patroni reinitialisation (PR #660)
  • Fixed some postgresql.conf parameters for hardening (PR #621) (DPE-5512)
  • Fixed lib check (PR #627)
Libraries, testing, and CI
  • Data Interafces v40 (PR #615) (DPE-5306)
  • Bump libs and remove TestCase (PR #622)
  • Run tests against juju 3.6 on a nightly schedule (PR #601) (DPE-4977)
  • Test against juju 3.6/candidate + upgrade dpw to v23.0.5 (PR #675)
  • Lock file maintenance Python dependencies (PR #644)
  • Migrate config .github/renovate.json5 (PR #673)
  • Switch from tox build wrapper to charmcraft.yaml overrides (PR #626)
  • Update canonical/charming-actions action to v2.6.3 (PR #608)
  • Update codecov/codecov-action action to v5 (PR #674)
  • Update data-platform-workflows to v23.0.5 (PR #676)
  • Update dependency cryptography to v43.0.1 [SECURITY] (PR #614)
  • Update dependency ubuntu to v24 (PR #631)
  • Update Juju agents (PR #634)
  • Bump libs (PR #677)
  • Increase linting rules (PR #649) (DPE-5324)

Known limitations

Requirements and compatibility

  • (no change) Minimum Juju 2 version: v.2.9.49
  • (no change) Minimum Juju 3 version: v.3.4.3

See the system requirements for more details about Juju versions and other software and hardware prerequisites.

Integration tests

Below are some of the charm integrations tested with this revision on different Juju environments and architectures:

  • Juju v.2.9.51 on amd64
  • Juju v.3.4.6 on amd64 and arm64
Software Revision Tested on
postgresql-test-app rev 281 juju-2_amd64 juju-3_amd64
rev 279 juju-2_amd64 juju-3_amd64
rev 280 juju-3_arm64
rev 278 juju-3_arm64
data-integrator rev 41 juju-2_amd64 juju-3_amd64
rev 40 juju-3_arm64
nextcloud rev 26 juju-2_amd64 juju-3_amd64
s3-integrator rev 77 juju-2_amd64 juju-3_amd64
rev 78 juju-3_arm64
tls-certificates-operator rev 22 juju-2_amd64
self-signed-certificates rev 155 juju-3_amd64
rev 205 juju-3_arm64
mailman3-core rev 18 juju-2_amd64 juju-3_amd64 juju-3_arm64
landscape-client rev 70 juju-2_amd64 juju-3_amd64 juju-3_arm64
ubuntu-advantage rev 137 juju-2_amd64 juju-3_amd64
rev 139 juju-3_arm64

See the /lib/charms directory on GitHub for details about all supported libraries.

See the metadata.yaml file on GitHub for a full list of supported interfaces.

Packaging

This charm is based on the Charmed PostgreSQL snap revision 132/133. It packages: