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:
  • ubuntu-advantage (PR#397) (DPE-3644)
  • landscape-client (PR#388) (DPE-3644)
• 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
  • 14.11-0ubuntu0.22.04.1
• pgbouncer v.1.21
  • 1.21.0-0ubuntu0.22.04.1~ppa1
• patroni v.3.1.2
  • 3.1.2-0ubuntu0.22.04.1~ppa2
• pgBackRest v.2.48
  • 2.48-0ubuntu0.22.04.1~ppa1
• 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
• 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

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.