Revisions 467, 468

A new revision of Charmed PostgreSQL for machines 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.

Highlights

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

  • Check the official PostgreSQL release notes

• Added support for Point In Time Recovery ( #391) (DPE-2582)

Minor features

• Secure Syncobj and Patroni with passwords ( #596) (DPE-5269)

• Removed deprecated config option profile-limit-memory ( #564) (DPE-4889)

• Added URI connection string to relations ( #527) (DPE-2278)

• Moved URI generation to update endpoints ( #584)

• Improve list-backups action output ( #522) (DPE-4479)

• Show start/end time in UTC time in list-backups output ( #551)

• Switched to constant snap locales ( #559) (DPE-4198)

Bug fixes

• Wait for exact number of units after scale down ( #565) (DPE-5029)

• Improved test stability by pausing Patroni in the TLS test ( #534) (DPE-4533)

• Block charm if it detects objects dependent on disabled plugins ( #560) (DPE-4967)

• Disabled pgBackRest service initialization ( #530) (DPE-4345)

• Increased timeout and terminate processes that are still up ( #514) (DPE-4532)

• Fixed GCP backup test ( #521) (DPE-4820)

• Handled on start secret exception and remove stale test ( #550)

• Removed block on failure to get the db version ( #578) (DPE-3562)

• Updated unit tests after fixing GCP backup test ( #528) (DPE-4820)

• Ported some test_self_healing CI fixes + update check for invalid extra user credentials ( #546) (DPE-4856)

• Fixed slow bootstrap of replicas ( #510) (DPE-4759)

• Fixed conditional password ( #604)

• Added enforcement of Juju versions ( #518) (DPE-4809)

• Fixed a missing case for peer to secrets translation. ( #533)

• Updated README.md ( #538) (DPE-4901)

• Increased test coverage ( #505)

Full Changelog: https://github.com/canonical/postgresql-operator/compare/rev429…rev467

Known limitations

• The unit action resume-upgrade randomly raises a harmless error message: terminated.

• The Sysbench charm 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 the cluster-cluster replication upgrade with you.

Requirements

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

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