Revisions 774, 775

k8s

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

Compatibility

Architecture

Charm revision

OCI image revision*

PostgreSQL version

Min. recommended Juju version

amd64

774

184

14.20

3.6.1+

arm64

775

184

14.20

3.6.1+

*OCI image resources: postgresql-image=ghcr.io/canonical/charmed-postgresql@sha256:876a6efcfd9093d6a02d992f3c6f0b9948dcf17ec6d87fa40f19b9d1db5b0b12

Highlights

Other features

  • [DPE-7549] Speed up backup creation and restore by @dragomirp in #1019

  • Several improvements to configuration options:

    • [DPE-6679] Added new PostgreSQL config parameters by @Pepsiqqq in #867

    • [DPE-6675] Add wal_keep_size config option by @marceloneppel in #892

    • [DPE-8861] Added worker process and WAL compression config options by @onkolahmet in #1191

  • [DPE-6555] Add read only URIs by @dragomirp in #875

  • [DPE-6664] Make username mandatory in set-password by @dragomirp in #934

  • Add degraded status to primary message by @dragomirp in #874

  • [DPE-6484] Add scope to promote to primary by @dragomirp in #850

  • [DPE-6910] Remove duplicate parameters specification by @marceloneppel in #896

  • [DPE-6899] User->databases pg_hba rules by @marceloneppel in #919

  • Update libs and remove warning by @dragomirp in #1014

  • [DPE-9001] Cache _patroni property by @taurus-forever in #1187

  • Parallel calls to Patroni API and TLS tweaks by @dragomirp in #1200

  • [DPE-9361] Strict mode configuration by @dragomirp in #1234

  • [DPE-9444] Switch to ops tracing (14/edge) by @dragomirp in #1279

  • Update links to Ops tutorial and the charm source code by @dwilding in #1015

  • Update ghcr.io/canonical/charmed-postgresql Docker tag to v14.18 (main) by @renovate[bot] in #983

Bug fixes

  • [DPE-6323] Handle missing stanza output by @dragomirp in #866

  • [DPE-6662] Fix pgbackrest logs names on logs rotation by @taurus-forever in #996

  • [DPE-6344] Persist transferred certificates upon start by @sinclert-canonical in #953

  • [DPE-5311] Patch failsafe mode on upgrade by @dragomirp in #1051

  • [DPE-8005] Handle empty region by @dragomirp in #1100

  • [DPE-8975] Move PG14 K8s TLS tests to 1/stable by @taurus-forever in #1160

  • [DPE-9158][DPE-9370] Limit repo listing to find the timelines by @dragomirp in #1239

  • [DPE-7891] test: re-enable discourse integration test by @marceloneppel in #1265

  • [DPE-9448] Don’t override upgrade status by @dragomirp in #1284

  • [DPE-9448] Preserve upgrade statuses during rolling restart by @dragomirp in #1300

  • [DPE-6809] fix(backups): include pgBackRest error details in S3 stanza failure messages by @marceloneppel in #1243

  • Add missing connection vars by @sinclert-canonical in #920

  • Don’t set tls flag if relation isn’t initialised by @dragomirp in #933

  • Extend relation-user listing syntax by @sinclert-canonical in #957

  • docs: Fix broken URLs and spelling errors by @a-velasco in #993

  • Early set of read-only-endpoints by @dragomirp in #1072

  • Waiting for the wrong username by @dragomirp in #1122

  • Lock file maintenance Python dependencies (main) by @renovate[bot] in #1170

  • Update canonical/data-platform-workflows action to v40 (main) by @renovate[bot] in #1169

  • fix: query Patroni-labeled resources for Juju 3.6.13+ by @marceloneppel in #1219

  • Fix grafana template by @enriqueesanchz in #1285

New contributors

  • @Pepsiqqq made their first contribution in #867

  • @izmalk made their first contribution in #921

  • @dwilding made their first contribution in #1015

  • @onkolahmet made their first contribution in #1191

  • @NucciTheBoss made their first contribution in #1202

  • @enriqueesanchz made their first contribution in #1285

Full Changelog: https://github.com/canonical/postgresql-k8s-operator/compare/rev494…rev774