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