Skip to main content

Your submission was sent successfully! Close

Thank you for contacting us. A member of our team will be in touch shortly. Close

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

This page is a work in progress for a release in the near future. 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
- Integration tests
- Packaging

Highlights

Timeline Management (PR #629) (DPE-5561)
Add pgAudit (PR #612) (DPE-5248)
postgresql.conf hardening (PR #621) (DPE-5512)
Integrate with Tempo HA + relay tracing traffic through grafana-agent (PR #640)
polish cos dashboard (PR #646)
Update COS alert rules (PR #651) (DPE-5658)
S3 Improvements (PR #642)

Features and improvements

Split PITR backup test in AWS and GCP (PR #605) (DPE-5181)
Remove patching of private ops class. (PR #617)
[MISC] Use more meaningful group naming for multi-group tests (PR #625)
Ignore alias error in case alias is already existing (PR #637)
Stop tracking channel for held snaps (PR #638)
tf module on charm (PR #643)
Add pgBackRest logrotate configuration (PR #645) (DPE-5601)
Grants priviledges to non-public schemas (PR #647) (DPE-5387)
add tls and tls-ca fields to databag (PR #666)
Merge update_tls_flag into update_endpoints (PR #669)
Quote tox.ini repository paths (PR #678) (DPE-6042)
Add microceph (local backup) integration test + bump snap version (PR #633) (DPE-5386)

Bugfixes and maintenance

Add warning logs to Patroni reinitialisation (PR #660)
Fix 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

This charm revision features the following changes in dependencies: …

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`
	`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 ]. It packages:

postgresql v.14.13
pgbouncer v.1.21
patroni v.3.1.2
pgBackRest v.2.53
prometheus-postgres-exporter v.0.12.1

Previous Release Notes Next Revision 467/468

Last updated 17 hours ago. Help improve this document in the forum.