Reference > Release Notes > All revisions > Revision 381/382

Revision 381/382

_{September 11, 2024}

Dear community,

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 K8s charm now releases multiple revisions simultaneously:

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

To make sure you deploy for the right architecture, we recommend setting an architecture constraint for your entire juju model.

Otherwise, it can be done at deploy time with the --constraints flag:

juju deploy postgresql-k8s --trust --constraints arch=<arch> 

where <arch> can be amd64 or arm64.

Highlights

• Upgraded PostgreSQL from v.14.11 → v.14.12 (PR #563)
  • Check the official PostgreSQL release notes
• Added support for Point In Time Recovery (PR #554) (DPE-4839)
• Added COS tracing support with tempo-k8s (PR #497) (DPE-4617)

Features

• Added user warning when deploying charm with wrong architecture (PR #613) (DPE-4239)
• Improved backups behavior (PR #542) (DPE-4479)
• Add libpq’s connection string URI format to uri field in relation databag (PR #545) (DPE-2278)
• Changed ‘master’ to ‘primary’ in Patroni leader role (PR #532) (DPE-1177)
• Added password to Patroni’s REST API (PR #661) (DPE-5275)
• Improve pgbackrest logging (PR #587)

Bugfixes and stability

• Restart pebble service if it’s down (PR #581) (DPE-4806)
• Switched test app interface (PR #595)
• Addeded missing await to invalid_extra_user_roles integration test + fix check loop (PR #602)
• Fixed UTC time zone (PR #592)
• Fix PITR test on Juju 2.9 (PR #596) (DPE-4990)
• Fixed storage ownership (PR #580) (DPE-4227)
• Fixed get-password action description (PR #605) (DPE-5019)
• Quick fix for blocked CI (PR #533)
• CI stability fixes + slicing tests (PR #524) (DPE-4620)
• Added test for relations coherence (PR #505)
• Addressed test_charm and test_self_healing instabilities (PR #510) (DPE-4594)
• Split PITR backup test in AWS and GCP (PR #664) (DPE-5244)
• Import JujuVersion from ops.jujuversion instead of ops.model (PR #640)
• Don’t block on missing Postgresql version (PR #626) (DPE-3562)
• Run integration tests on arm64 (PR #478)
• Improved async replication stability (PR #526) (DPE-4736)
• Removed deprecated config option profile-limit-memory (PR #608)
• Pause Patroni in the TLS test (PR #588) (DPE-4533)
• Enforce Juju versions (PR #544) (DPE-4811)
• Block charm if plugin disable fails due to dependent objects (PR #567) (DPE-4801)
• Temporarily disable log forwarding & fix for race in Patroni REST password setup (PR #663)
• Use manifest file to check for charm architecture (PR #665) (DPE-4239)
• Only write app data if leader (PR #676) (DPE-5325)
• Added log for fix_leader_annotation method (PR #679)

Known limitations

• The unit action resume-upgrade randomly raises a harmless error message: terminated.
• The charm sysbench may crash during a PostgreSQL charm refresh.
• Make sure that cluster-cluster replication is requested for the same charm/workload revisions. An automated check is planned.
• Contact us to schedule a cluster-cluster replication upgrade with you.

If you are jumping over several stable revisions, check previous release notes before upgrading.

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

Dependencies

This revision was explicitly tested with the following dependencies:

• microk8s v.1.31 - Channel strict/stable
• data-integrator - Revision 41
• indico - Revision 213
• discourse-k8s - Revision 124
• postgresql-test-app - Revision 239
• s3-integrator - Revision 31
• Juju v.2.9.50 on amd64
  • tls-certificates-operator - Channel legacy/stable, Revision 22
• Juju v.3.4.5 on amd64 and arm64
  • self-signed-certificates - Channel latest/stable, Revision 155

Packaging

This charm is based on the Charmed PostgreSQL K8s rock image. It packages:

• postgresql v.14.12
• pgbouncer v.1.21
• patroni v.3.1.2
• pgBackRest v.2.48
• prometheus-postgres-exporter v.0.12.1

See the /lib/charms directory on GitHub for more details about all supported libraries.
See the metadata.yaml file on GitHub for a full list of supported interfaces.

Dependencies and automations

This section contains some technical details about the charm’s contents and dependencies.

• Updated canonical/charming-actions action to v2.6.3 (PR #673)
• Updated data-platform-workflows to v21.0.1 (PR #660)
• Updated dependency canonical/microk8s to v1.31 (PR #632)
• Updated dependency cryptography to v43.0.1(PR #681)
• Updated dependency juju/juju to v2.9.50 (PR #589)
• Updated dependency juju/juju to v3.4.5 (PR #599)
• Updated dependency tenacity to v9 (PR #600)
• Updated ghcr.io/canonical/charmed-postgresql:14.12-22.04_edge Docker digest to 7ef86a3 (PR #655)
• Updated rock to 14.12 (PR #563)
• Switch Jira issue sync from workflow to bot (PR #636)
• Use poetry package-mode=false (PR #594)
• Updated logging: bump lib and introduce pebble log forwarding (PR #486)
• Updated postgresql lib (PR #546)
• Bumped coverage (PR #623)
• Test service patch lib update (PR #624)