Charmed PostgreSQL VM
- By Canonical Data Platform
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 345 | 09 Nov 2023 | |
latest/stable | 239 | 09 Feb 2022 | |
latest/stable | 226 | 01 Apr 2021 | |
14/stable | 468 | 11 Sep 2024 | |
14/stable | 467 | 11 Sep 2024 | |
14/candidate | 468 | 02 Sep 2024 | |
14/candidate | 467 | 02 Sep 2024 | |
14/beta | 468 | 02 Sep 2024 | |
14/beta | 467 | 02 Sep 2024 | |
14/edge | 482 | 27 Sep 2024 | |
14/edge | 481 | 27 Sep 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
Reference > Release Notes > All revisions > Revision 429/430
Revision 429/430
June 28, 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 two revisions simultaneously:
- Revision 429 is built for
amd64
- Revision 430 is built for for
arm64
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
Below are the major highlights of this release. To see all changes since the previous stable release, check the release notes on GitHub.
- Upgraded PostgreSQL from v.14.10 → v.14.11 (PR #432)
- Check the official PostgreSQL release notes
- Added support for ARM64 architecture (PR #381)
- Added support for cross-regional asynchronous replication (PR #452) (DPE-2953)
- This feature focuses on disaster recovery by distributing data across different servers. Check our new how-to guides for a walkthrough of the cross-model setup, promotion, switchover, and other details.
- Added support for tracing with Tempo K8s (PR #485) (DPE-4616)
- Check our new guide: How to enable tracing
- Released new Charmed Sysbench operator for easy performance testing
Enhancements
- Added timescaledb plugin/extension (PR#470)
- See the Configuration tab for a full list of supported plugins/extensions
- Added incremental and differential backup support (PR #479) (DPE-4462)
- Check our guide: How to create and list backups
- Added support for disabling the operator (PR#412) (DPE-2469)
- Added support for subordination with:
- Added configuration option for backup retention time (PR#474)(DPE-4401)
- Added
experimental_max_connections
config option (PR#472) - Added check for replicas encrypted connection (PR#437)
Bugfixes
- Fixed slow charm bootstrap time (PR#413)
- Fixed large objects ownership (PR#349)
- Fixed secrets crash for “certificates-relation-changed” after the refresh (PR#475)
- Fixed network cut tests (PR#346) (DPE-3257)
Canonical Data issues are now public on both Jira and GitHub.
For a full list of all changes in this revision, see the GitHub Release.
Technical details
This section contains some technical details about the charm’s contents and dependencies. Make sure to also check the system requirements.
If you are jumping over several stable revisions, check previous release notes before upgrading.
Packaging
This charm is based on the charmed-postgresql
snap (pinned revision 113). It packages:
- postgresql
v.14.11
- 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
Contact us
Charmed PostgreSQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.
- Raise software issues or feature requests on GitHub
- Report security issues through Launchpad
- Contact the Canonical Data Platform team through our Matrix channel.