Revisions 467, 468

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

See also: Releases overview page, How to perform an upgrade

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 (PR #530)
  • Check the official PostgreSQL release notes
• Added support for Point In Time Recovery (PR #391) (DPE-2582)

Minor features

• Secure Syncobj and Patroni with passwords (PR #596) (DPE-5269)
• Removed deprecated config option profile-limit-memory (PR #564) (DPE-4889)
• Added URI connection string to relations (PR #527) (DPE-2278)
• Moved URI generation to update endpoints (PR #584)
• Improve list-backups action output (PR #522) (DPE-4479)
• Show start/end time in UTC time in list-backups output (PR #551)
• Switched to constant snap locales (PR #559) (DPE-4198)

Bug fixes

• Wait for exact number of units after scale down (PR #565) (DPE-5029)
• Improved test stability by pausing Patroni in the TLS test (PR #534) (DPE-4533)
• Block charm if it detects objects dependent on disabled plugins (PR #560) (DPE-4967)
• Disabled pgBackRest service initialization (PR #530) (DPE-4345)
• Increased timeout and terminate processes that are still up (PR #514) (DPE-4532)
• Fixed GCP backup test (PR #521) (DPE-4820)
• Handled on start secret exception and remove stale test (PR #550)
• Removed block on failure to get the db version (PR #578) (DPE-3562)
• Updated unit tests after fixing GCP backup test (PR #528) (DPE-4820)
• Ported some test_self_healing CI fixes + update check for invalid extra user credentials (PR #546) (DPE-4856)
• Fixed slow bootstrap of replicas (PR #510) (DPE-4759)
• Fixed conditional password (PR #604)
• Added enforcement of Juju versions (PR #518) (DPE-4809)
• Fixed a missing case for peer to secrets translation. (PR #533)
• Updated README.md (PR #538) (DPE-4901)
• Increased test coverage (PR #505)

Full Changelog: 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.