Reference > Release Notes > All revisions > Revision 462/463
This page is a work in progress for a release in the near future. Please revisit at a later date!
Revision 462/463
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 is built for
amd64on Ubuntu 22.04 LTS - Revision is built for
arm64on 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
- Timeline Management (PR #716) (DPE-5581)
- Add pgAudit (PR #688) (DPE-5116)
- postgresql.conf hardening (PR #702) (DPE-5511)
- Integrate with Tempo HA + test relay support of tracing traffic through grafana-agent-k8s (PR #725)
- Polish COS dashboard (PR #733) (DPE-4469)
- Update COS alert rules (PR #727) (DPE-5658)
- S3 improvements (PR #750)
Features and improvements
- Remove patching of private ops class. (PR #692)
- Add check for low storage space on pgdata volume (PR #685) (DPE-5301)
- Re-enable log forwarding (PR #671)
- Avoid replication slot deletion (PR #680) (DPE-3887)
- CC006 compliance (PR #737) (DPE-5627)
- Add pgBackRest logrotate configuration (PR #722) (DPE-5600)
- Grants priviledges to non-public schemas (PR #742) (DPE-5387)
- Add TLS flag + CA to relation databag (PR #719) (DPE-5484)
- Add warning logs to Patroni reinitialisation (PR #753) (DPE-5712)
- Reduce pgdate permissions (PR #759) (DPE-5915)
- Split off new interface client app tests (PR #761)
- Temporarily disable log forwarding (PR #757)
- Change 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
- Fixes for PITR backup test instabilities (PR #690)
- Early exit on missing s3 rel (PR #762) (DPE-5934)
- Fix 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
…
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.51onamd64 - Juju
v.3.4.6onamd64andarm64
| 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 ]. 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