Revisions 280, 281

A new revision of Charmed PostgreSQL for Kubernetes has been published in the 14/stable channel.

Charmhub • System requirements • How to deploy • How to upgrade • All release notes

What’s changed

This section outlines the most important highlights, features and bug fixes in this release.

• PostgreSQL has been upgraded from v.14.10 to v.14.11 ( #432 ).

  • Check the official PostgreSQL release notes

• Added support for ARM64 architecture ( #408 )

• Added support for cross-regional asynchronous replication ( #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 ( #497 )

  • See: How to enable tracing

• Released new Charmed Sysbench operator for easy performance testing.

Features

• Added timescaledb plugin/extension ( #488 )

  • See the Configuration tab for all parameters.

• Added incremental and differential backup support ( #487 )( #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 ( #477 )(DPE-4401 )

  • See the Configuration tab for all parameters

• Added message to inform users about missing --trust flag ( #440 )(DPE-3885 )

• Added experimental_max_connections config option ( #500 )

• Introduced a block on legacy roles request (modern interface only) ( #391 )(DPE-3099 )

Bug fixes

• Fixed large objects ownership ( #390 )(DPE-3551 )

• Fixed shared buffers validation ( #396 )(DPE-3594 )

• Fixed handling S3 relation in primary non-leader unit ( #375 )(DPE-3349 )

• Stabilized SST and network cut tests ( #385 )(DPE-3473 )

• Fixed pod reconciliation: re-render config/service on pod recreation ( #461 )(DPE-2671 )

• Addressed main instability sources on backups integration tests ( #496 )(DPE-4427 )

• Fixed scale up with S3 and TLS relations in ( #489 )(DPE-4456 )

Canonical Data issues are now public on both Jira and GitHub .

Full Changelog: https://github.com/canonical/postgresql-k8s-operator/compare/rev193…rev280

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

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.