Charmed PostgreSQL VM

Architecture:

Base version:

Channel	Revision	Published	Runs on
latest/stable	345	09 Nov 2023	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable	239	09 Feb 2022	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable	226	01 Apr 2021	Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable	468	11 Sep 2024	Ubuntu 22.04
14/stable	467	11 Sep 2024	Ubuntu 22.04
14/candidate	468	02 Sep 2024	Ubuntu 22.04
14/candidate	467	02 Sep 2024	Ubuntu 22.04
14/beta	468	02 Sep 2024	Ubuntu 22.04
14/beta	467	02 Sep 2024	Ubuntu 22.04
14/edge	472	07 Sep 2024	Ubuntu 22.04
14/edge	471	07 Sep 2024	Ubuntu 22.04

Platform:

22.04 20.04 18.04 16.04 14.04

Share your thoughts on this charm with the community on discourse.

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:

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.

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)

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)

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.

See the system requirements page for more details about software and hardware prerequisites.

This charm is based on the Charmed PostgreSQL snap Revision 120/121 . It packages:

This charm revision imports the following libraries:

grafana_agent v0 for integration with Grafana
- Implements cos_agent interface
rolling_ops v0 for rolling operations across units
- Implements rolling_op interface
tempo_k8s v1, v2 for integration with Tempo charm
- Implements tracing interface
tls_certificates_interface v2 for integration with TLS charms
- Implements tls-certificates interface

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.

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