Revisions 381, 382

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.

• Upgraded PostgreSQL from v.14.11 → v.14.12 ( #563 )

  • Check the official PostgreSQL release notes

• Added support for Point In Time Recovery ( #554 ) (DPE-4839 )

• Added COS tracing support with tempo-k8s ( #497 ) (DPE-4617 )

Features

• Added user warning when deploying charm with wrong architecture ( #613 ) (DPE-4239 )

• Improved backups behavior ( #542 ) (DPE-4479 )

• Add libpq’s connection string URI format to uri field in relation databag ( #545 ) (DPE-2278 )

• Changed ‘master’ to ‘primary’ in Patroni leader role ( #532 ) (DPE-1177 )

• Added password to Patroni’s REST API ( #661 ) (DPE-5275 )

• Improve pgbackrest logging ( #587 )

Bug fixes

• Restart pebble service if it’s down ( #581 ) (DPE-4806 )

• Switched test app interface ( #595 )

• Added missing await to invalid_extra_user_roles integration test + fix check loop ( #602 )

• Fixed UTC time zone ( #592 )

• Fix PITR test on Juju 2.9 ( #596 ) (DPE-4990 )

• Fixed storage ownership ( #580 ) (DPE-4227 )

• Fixed get-password action description ( #605 ) (DPE-5019 )

• Quick fix for blocked CI ( #533 )

• CI stability fixes + slicing tests ( #524 ) (DPE-4620 )

• Added test for relations coherence ( #505 )

• Addressed test_charm and test_self_healing instabilities ( #510 ) (DPE-4594 )

• Split PITR backup test in AWS and GCP ( #664 ) (DPE-5244 )

• Import JujuVersion from ops.jujuversion instead of ops.model ( #640 )

• Don’t block on missing Postgresql version ( #626 ) (DPE-3562 )

• Run integration tests on arm64 ( #478 )

• Improved async replication stability ( #526 ) (DPE-4736 )

• Removed deprecated config option profile-limit-memory ( #608 )

• Pause Patroni in the TLS test ( #588 ) (DPE-4533 )

• Enforce Juju versions ( #544 ) (DPE-4811 )

• Block charm if plugin disable fails due to dependent objects ( #567 ) (DPE-4801 )

• Temporarily disable log forwarding & fix for race in Patroni REST password setup ( #663 )

• Use manifest file to check for charm architecture ( #665 ) (DPE-4239 )

• Only write app data if leader ( #676 ) (DPE-5325 )

• Added log for fix_leader_annotation method ( #679 )

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

Known limitations

• 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 a cluster-cluster replication upgrade with you.

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.5.

See the system requirements for more details about Juju versions and other software and hardware prerequisites.