Revisions 951, 952

vm

A new revision of Charmed PostgreSQL for machines has been published in the 16/stable channel.

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: https://github.com/canonical/postgresql-operator/compare/v16/1.59.0…v16/1.134.0