Reference > Release Notes > All revisions > Revision 467/468
Revision 467/468
September 11, 2024
Dear community,
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 468 is built for
amd64
on Ubuntu 22.04 LTS - Revision 467 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 --constraints arch=<arch>
where <arch>
can be amd64
or arm64
.
Highlights
- Upgraded PostgreSQL from v.14.11 → v.14.12 (PR #530)
- Check the official PostgreSQL release notes
- Added support for Point In Time Recovery (PR #391) (DPE-2582)
- Secure Syncobj and Patroni with passwords (PR #596) (DPE-5269)
- Removed deprecated config option
profile-limit-memory
(PR #564) (DPE-4889)
Features
- Added URI connection string to relations (PR #527) (DPE-2278)
- Improve
list-backups
action output (PR #522) (DPE-4479) - Show start/end time in UTC time in list-backups output (PR #551)
- Switched to constant snap locales (PR #559) (DPE-4198)
- Moved URI generation to update endpoints (PR #584)
Bugfixes
- Wait for exact number of units after scale down (PR #565) (DPE-5029)
- Improved test stability by pausing Patroni in the TLS test (PR #534) (DPE-4533)
- Block charm if it detects objects dependent on disabled plugins (PR #560) (DPE-4967)
- Disabled pgBackRest service initialization (PR #530) (DPE-4345)
- Increased timeout and terminate processes that are still up (PR #514) (DPE-4532)
- Fixed GCP backup test (PR #521) (DPE-4820)
- Handled on start secret exception and remove stale test (PR #550)
- Removed block on failure to get the db version (PR #578) (DPE-3562)
- Updated unit tests after fixing GCP backup test (PR #528) (DPE-4820)
- Ported some
test_self_healing
CI fixes + update check for invalid extra user credentials (PR #546) (DPE-4856) - Fixed slow bootstrap of replicas (PR #510) (DPE-4759)
- Fixed conditional password (PR #604)
- Added enforcement of Juju versions (PR #518) (DPE-4809)
- Fixed a missing case for peer to secrets translation. (PR #533)
- Updated README.md (PR #538) (DPE-4901)
- Increased test coverage (PR #505)
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 the cluster-cluster replication upgrade with you.
If you are jumping over several stable revisions, check previous release notes before upgrading.
Requirements
See the system requirements page for more details about software and hardware prerequisites.
Packaging
This charm is based on the Charmed PostgreSQL snap Revision 120/121 . 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
Libraries and interfaces
This charm revision imports the following libraries:
- grafana_agent
v0
for integration with Grafana- Implements
cos_agent
interface
- Implements
- rolling_ops
v0
for rolling operations across units- Implements
rolling_op
interface
- Implements
- tempo_k8s
v1
,v2
for integration with Tempo charm- Implements
tracing
interface
- Implements
- tls_certificates_interface
v2
for integration with TLS charms- Implements
tls-certificates
interface
- Implements
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.
- Added jinja2 as a dependency (PR #520) (DPE-4816)
- Switched Jira issue sync from workflow to bot (PR #586)
- Updated canonical/charming-actions action to v2.6.2 (PR #523)
- Updated data-platform-workflows to v21.0.1 (PR #599)
- Updated dependency cryptography to v43 (PR #539)
- Updated dependency tenacity to v9 (PR #558)
- Updated Juju agents (patch) (PR #553)
- Switch to resusable presets (PR #513)
- Use poetry package-mode=false (PR #556)
- Switched test-app interface (PR #557)