Charmed PostgreSQL VM
- Canonical
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 345 | 09 Nov 2023 | |
latest/stable | 239 | 09 Feb 2022 | |
latest/stable | 226 | 01 Apr 2021 | |
14/stable | 468 | 11 Sep 2024 | |
14/stable | 467 | 11 Sep 2024 | |
14/candidate | 529 | 29 Nov 2024 | |
14/candidate | 528 | 29 Nov 2024 | |
14/beta | 529 | 28 Nov 2024 | |
14/beta | 528 | 28 Nov 2024 | |
14/edge | 531 | 29 Nov 2024 | |
14/edge | 530 | 29 Nov 2024 | |
16/edge | 527 | 27 Nov 2024 | |
16/edge | 526 | 27 Nov 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
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
- Features and improvements
- Bugfixes and maintenance
- Known limitations
- Requirements and compatibility
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
totempo_coordinator_k8s
and relay tracing traffic throughgrafana-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
andtls-ca
fields to databag (PR #666) - Merged
update_tls_flag
intoupdate_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
onamd64
- Juju
v.3.4.6
onamd64
andarm64
Software | Revision | Tested on | |
---|---|---|---|
postgresql-test-app | rev 281 |
||
rev 279 |
|||
rev 280 |
|||
rev 278 |
|||
data-integrator | rev 41 |
||
rev 40 |
|||
nextcloud | rev 26 |
||
s3-integrator | rev 77 |
||
rev 78 |
|||
tls-certificates-operator | rev 22 |
||
self-signed-certificates | rev 155 |
||
rev 205 |
|||
mailman3-core | rev 18 |
||
landscape-client | rev 70 |
||
ubuntu-advantage | rev 137 |
||
rev 139 |
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:
- postgresql
v.14.12
- pgbouncer
v.1.21
- patroni
v.3.1.2
- pgBackRest
v.2.53
- prometheus-postgres-exporter
v.0.12.1