Revisions 935, 936

vm

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

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

Compatibility

Architecture

Charm revision

Snap version

PostgreSQL version

Recommended Juju version

amd64

936

229

14.19

3.6.1+

arm64

935

230

14.19

3.6.1+

Features

  • [DPE-8296] Updated PostgreSQL from 14.15 to 14.19 ( #1147)

  • [DPE-8470] Updated Patroni to 3.3.8 ( #1197)

    • Set all nodes to synchronous replicas by default ( #672) )

    • Enable Patroni synchronous strict mode ( #1196)

    • Make scope mandatory for the promote-to-primary action ( #856)

    • Prevented restarts during initial sync ( #1000)

    • Removed re-initialization for delayed replication ( #1168)

    • Automate raft re-initialization (disaster recovery) ( #611)

  • [DPE-6898] Restrict user-to-database access via pg_hba rules ( #885)

  • Speedup deployments by hashing configuration ( #1166)

  • [DPE-6345] Introduced LDAP integration ( #824)

  • [DPE-6678] Expand Charmed PostgreSQL configurations ( #778)

    • new wal_keep_size config option ( #799)

    • new max_locks_per_transaction config option ( #718)

  • [DPE-6555] Added read-only URIs ( #783)

  • [DPE-6664] Made username mandatory in the set-password action ( #846)

  • [DPE-7549] Added backup compression and restore max-process options ( #1009)

  • [DPE-6062] Allow backup --restore-to-time=latest without a backup-id ( #683)

  • Added conditional expose Terraform directive ( #853)

  • Updated versions and release documentation ( #1158)

  • [SECURITY] Updated dependency cryptography to v44.0.1 ( #764)

Bug fixes

  • [DPE-6323] Handle missing stanza output ( #727)

  • [DPE-6874] Poll all members in the cluster topology script ( #810)

  • Extended relation-user listing syntax ( #868)

  • [DPE-7723] Corrected architecture for revisions 429/430 in releases.md ( #1046)

  • [DPE-6259] Fixed pgbackrest configuration permissions ( #1038)

  • [DPE-7968] Bumped snap revision (removed python3-boto3 for CVE-2023-37920) ( #1109)

  • Prevent blocking if the snap could not be installed ( #1136)

  • Restore raft encryption check on upgrade ( #1146)

  • [DPE-8005] Handle empty region values ( #1157)

  • [DPE-8296] Downgraded promote.yaml to _promote_charm.yaml@v31.1.1 ( #1161)

  • [DPE-8337] Disabled Patroni configuration to prevent possible data loss ( #1173)

  • [DPE-8430][DPE-8427] Muted error message to debug level and improved creation of access roles ( #1186)

New Contributors

  • @Pepsiqqq made their first contribution in #778

  • @izmalk made their first contribution in #827

  • @swetha1654 made their first contribution in #853

  • @tushar5526 made their first contribution in #1018

  • @Gere321123 made their first contribution in #1033

Full Changelog: https://github.com/canonical/postgresql-operator/compare/rev552…rev935