Revisions 951, 952

A new revision of Charmed PostgreSQL VM has been published in the 16/stable channel on Charmhub.

This release upgrades the PostgreSQL version to 16.10.

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Minimum Juju version
amd64	952	239	16.10	3.6.1+
arm64	951	240	16.10	3.6.1+

Highlights

• [DPE-8296] Bump PostgreSQL to 16.10 by @taurus-forever in #1150
  • Check the official PostgreSQL 16.10 release notes
• [DPE-8550] Remove old Juju Secrets revision in Juju 3.6.11+ by @dragomirp in #1215
• [DPE-8470] Bump Patroni from 3.2.2 to 3.3.8 by @taurus-forever in #1198
  • Enable Patroni strict sync mode by @dragomirp in #1199

Features

• [DPE-7379] Implement custom username by @dragomirp in #1100
• Increase max_replication_slots and max_wal_senders to 25 by @taurus-forever in #1037
• [DPE-7594] Sync up pg_hba changes and remove trigger by @dragomirp in #1051
• [DPE-6902] Replace md5 with scram-sha-256 in patroni/pg_hba.conf by @taurus-forever in #1004
• [DPE-7706] Update PostgreSQL TF module by @taurus-forever in #1052
• Change config options to dashes & update charm-refresh to v3.1.0.0 by @carlcsaposs-canonical in #1097
• Remove psql setpriv shim and switch stable upgrade tests to 16/stable by @dragomirp in #1041
• Reuse class PostgreSQL on each self.postgresql.* call by @taurus-forever in #1030
• Port pgbackrest exporter and switch to charm libs packages by @dragomirp in #1235
• Documentation updates and improvements
  • Versions and release documentation (16) by @a-velasco in #1141
  • Major Tutorial refactor by @a-velasco in #1040
  • Update architecture page (16) by @a-velasco in #1193

Bugfixes

• [DPE-6259] pgbackrest config perms by @dragomirp in #1036
• [DPE-7968] Bump snap revision (remove python3-boto3 for CVE-2023-37920) by @taurus-forever in #1108
• [DPE-7726] Use Patroni API for is_restart_pending() (instead of SQL select from pg_settings) by @taurus-forever in #1049
• Update charm-refresh to v3.1.0.2 by @carlcsaposs-canonical in #1118
• Prevent block if the snap cannot be installed by @dragomirp in #1135
• [DPE-8005] Handle empty region by @dragomirp in #1117
• Handle invalid stanza name by @dragomirp in #1154
• [DPE-8320] Fix backups with internal certificates by @dragomirp in #1162
• [DPE-8337] Disable Patroni config to prevent possible data loss by @taurus-forever in #1174
• Documentation: quick fix to use the new c lient-certificates relation by @nobuto-m in #1227
• [DPE-8550] Revision removal version check 16 by @dragomirp in #1215

New contributors

• @nobuto-m made their first contribution in #1227

Full Changelog: v16/1.59.0...v16/1.134.0