Charmed PostgreSQL K8s Reference | Revision 462/463

[avgomes (Andreia Velasco)]

Reference > Release Notes > All revisions > Revision 462/463

Revision 462/463

_{December 18, 2024}

Canonical’s newest Charmed PostgreSQL K8s 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 462 is built for amd64 on Ubuntu 22.04 LTS
• Revision 463 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
  • Packaging

---

Highlights

• Upgraded PostgreSQL from v.14.12 → v.14.13
  • Check the official PostgreSQL release notes
• Added timeline management to point-in-time recovery (PITR) (PR #716) (DPE-5581)
• Added pgAudit plugin/extension (PR #688) (DPE-5116)
• Observability stack (COS) improvements
  • Polished built-in Grafana dashboard (PR #733) (DPE-4469)
  • Improved COS alert rule descriptions (PR #727) (DPE-5658)
• Added fully-featured terraform module (PR #737) (DPE-5627)
• S3 backups improvements (PR #750)

Features and improvements

• Removed patching of private ops class. (PR #692)
• Switched charm libs from tempo_k8s to tempo_coordinator_k8s and test relay support of tracing traffic through grafana-agent-k8s (PR #725)
• Added check for low storage space on pgdata volume (PR #685) (DPE-5301)
• Re-enabled log forwarding (PR #671)
• Avoid replication slot deletion (PR #680) (DPE-3887)
• Added pgBackRest logrotate configuration (PR #722) (DPE-5600)
• Grant priviledges to non-public schemas (PR #742) (DPE-5387)
• Added TLS flag + CA to relation databag (PR #719) (DPE-5484)
• Added warning logs to Patroni reinitialisation (PR #753) (DPE-5712)
• Reduced pgdate permissions (PR #759) (DPE-5915)
• Split off new interface client app tests (PR #761)
• Temporarily disable log forwarding (PR #757)
• Changed owner of functions, procedures and aggregates (PR #773)
• Only update tls flags on leader (PR #770)
• Preload shared libs on normal PG start (PR #774) (DPE-6033)

Bugfixes and maintenance

• Fixed PITR backup test instabilities (PR #690)
• Fixed some postgresql.conf parameters for hardening (PR #702) (DPE-5511)
• Fixed event deferring issue with missing S3 relation (PR #762) (DPE-5934)
• Fixed connection rejection rule in pg_hba.conf (PR #751) (DPE-5689)

Libraries, testing, and CI

• [Hotfix] Remove failing tests from CI (PR #693)
• Reenable full cluster restart tests (PR #559) (DPE-5327)
• Reenable label rollback test (PR #754) (DPE-5693)
• Use more meaningful group naming for multi-group tests (PR #707)
• Reenable labelling tests (PR #728)
• increase async replication tests coverage (PR #748) (DPE-5662)
• Run integration tests against Juju 3.6 (PR #689) (DPE-4977)
• Lock file maintenance Python dependencies (PR #777)
• Migrate config .github/renovate.json5 (PR #769)
• Switch from tox build wrapper to charmcraft.yaml overrides (PR #708)
• Update codecov/codecov-action action to v5 (PR #771)
• Update data-platform-workflows to v23.0.5 (PR #776)
• Update dependency juju/juju to v2.9.51 (PR #717)
• Update dependency juju/juju to v3.4.6 (PR #720)
• Update dependency ubuntu to v24 (PR #711)
• Update ghcr.io/canonical/charmed-postgresql Docker tag to v14.13 (PR #658)

Known limitations

• Juju 3.6.1+ is required for Terraform-Provider-Juju consistent usage (more details here).

Requirements and compatibility

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

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
• Juju v.3.6.1 on amd64 and arm64

Software	Revision	Tested on
postgresql-test-app	rev 279
	rev 278
data-integrator	rev 41
	rev 40
s3-integrator	rev 77
	rev 78
tls-certificates-operator	rev 22
self-signed-certificates	rev 155
	rev 205
mattermost-k8s	rev 27
indico	rev 233
redis-k8s	rev 7
	rev 38
discourse-k8s	rev 173

Packaging

This charm is based on the Charmed PostgreSQL K8s ROCK revision 164. 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