Reference > Release Notes > All revisions > Revision 280/281

Revision 280/281

_{June 28, 2024}

Dear community,

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 two revisions simultaneously:

• Revision 281 is built for amd64
• Revision 280 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-k8s --constraints arch=<arch> --trust

where <arch> can be amd64 or arm64.

Highlights

• Upgraded PostgreSQL from v.14.10 → v.14.11 (PR #432)
  • Check the official PostgreSQL release notes
• Added support for ARM64 architecture (PR #408)
• Added support for cross-regional asynchronous replication (PR #447) (DPE-2897)
  • 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 #497)
  • Check the new guide: How to enable tracing
• Released new Charmed Sysbench operator for easy performance testing

Enhancements

• Added timescaledb plugin/extension (PR #488)
  • See the Configuration tab for all parameters.
• Added incremental and differential backup support (PR #487)(PR #476)(DPE-4464)
  • Check the guide: How to create and list backups
• Added support for disabling the operator (DPE-2470)
• Added configuration option for backup retention time (PR #477)(DPE-4401)
  • See the Configuration tab for all parameters
• Added message to inform users about missing --trust flag (PR #440)(DPE-3885)
• Added experimental_max_connections config option (PR #500)
• Introduced a block on legacy roles request (modern interface only) (PR#391)(DPE-3099)

Bugfixes

• Fixed large objects ownership (PR #390)(DPE-3551)
• Fixed shared buffers validation (PR #396)(DPE-3594)
• Fixed handling S3 relation in primary non-leader unit (PR #375)(DPE-3349)
• Stabilized SST and network cut tests (PR #385)(DPE-3473)
• Fixed pod reconciliation: rerender config/service on pod recreation (PR#461)(DPE-2671)
• Addressed main instability sources on backups integration tests (PR#496)(DPE-4427)
• Fixed scale up with S3 and TLS relations in (PR#489)(DPE-4456)

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.

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 K8s 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.