Reference > Release Notes > All revisions > Revision 462/463
This page is a work in progress for a future release. 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
- 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
- Added fully-featured terraform module (PR #737) (DPE-5627)
- Several S3 improvements (PR #750)
Features and improvements
- Removed patching of private ops class. (PR #692)
- Switched charm libs from
tempo_k8stotempo_coordinator_k8sand test relay support of tracing traffic throughgrafana-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.confparameters 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
…
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.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.12 - pgbouncer
v.1.21 - patroni
v.3.1.2 - pgBackRest
v.2.53 - prometheus-postgres-exporter
v.0.12.1