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.