Revisions 1161, 1162

A new revision of Charmed PostgreSQL VM has been published in the 14/stable channel on Charmhub.
System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Recommended Juju version
amd64	1162	334	14.23	3.6.24+
arm64	1161	333	14.23	3.6.24+

Features

• [DPE-10012] Bump PostgreSQL to 14.23 by @taurus-forever in #1701
  • Check the official PostgreSQL 14.23 release notes
• simplified validators code in config by @ugol in #1647

Bug fixes

• [DPE-9705] Add Patroni max_timelines_history=50 by @taurus-forever in #1631
• [DPE-9920] Fix 10th+ cluster<>cluster Primary promotions by @taurus-forever in #1644
• [DPE-10368] Bump replication lag defaults from 16kB to 100MB by @taurus-forever in #1763
• [DPE-10275] fix(tests): correct the location of the Harness cleanup by @marceloneppel in #1719
• Re-enable subordinated landscape-client tests on PG14 by @taurus-forever in #1624
• fix(backups): pass both stdout and stderr to _extract_error_message in _list_timelines by @SAY-5 in #1666
• fix: make create-replication action fail cleanly without async-replication relation by @SAY-5 in #1676

New Contributors

• @SAY-5 made their first contribution in #1667
• @ugol made their first contribution in #1647

Full Changelog: rev1090...rev1161

Revisions 1157, 1158

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

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Recommended Juju version
amd64	1158	366	16.14	3.6.21
arm64	1157	365	16.14	3.6.21

Highlights

• [DPE-10012] Bump PostgreSQL to 16.14
  • Check the official PostgreSQL 16.14 release notes
• [DPE-7316] Stereo mode via the new postgresql-watcher charm by @dragomirp in #1677
  • Documentation: How to deploy in stereo mode
• [DPE-9049] Storage: migrate all data mounts to versioned 16/main subdirectories by @marceloneppel in #1649
  • Fixed OpenStack deployments: lost+found folder issue.
  • Fixed patroni reinit
  • Fully automatically (via snap refresh), rollback supported (no downgrades!).
  • Contact us if you have questions/issues!

Other features and improvements

• [DPE-7316] Additive changes for stereo mode by @dragomirp in #1648
• [DPE-10017] Leader switchover update and faster topology cycle by @dragomirp in #1700 and #1681
• [DPE-10012] Rebuilt timescaledb extension for PostgreSQL 16.14 by @taurus-forever in #1720
• [DPE-10234] docs: add AGENTS.md/CLAUDE.md and expand CONTRIBUTING.md by @marceloneppel in #1705
• Use jubilant for main integration tests by @imanenami in #1507

Bug fixes

• [DPE-9010] fix(backups): reject standby backup actions and harden async replication by @marceloneppel in #1602
• [DPE-9920] Fix 10th+ cluster<>cluster Primary promotions by @taurus-forever in #1643
• [DPE-9705] Add Patroni max_timelines_history=50 by @taurus-forever in #1632
• [DPE-9995] docs(restore): fix restore-to-time format hint on 16/edge by @marceloneppel in #1668
• [DPE-9205] Update endpoint in pre-refresh check by @dragomirp in #1378
• [DPE-10283] test: remove redundant arch constraint from test_deploy_stable by @marceloneppel in #1741
• [DPE-10017] Wait for the primary cluster to stop on async switchover by @dragomirp in #1745
• Re-enable subordinated landscape-client tests by @taurus-forever in #1623

New Contributors

• @imanenami made their first contribution in #1507

Full Changelog: v16/1.242.0...v16/1.299.0

Revisions 1090, 1091

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

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Recommended Juju version
amd64	1090	281	14.22	3.6.21
arm64	1091	280	14.22	3.6.21

Features

• [DPE-9455] Bump PostgreSQL to 14.22 by @taurus-forever in #1508
• Bump snap to the latest security fixes by @taurus-forever in #1610
• [DPE-8932] Expose config parameters for pg_stat_statements by @dragomirp in #1520
• [DPE-9443] Switch to Ops tracing by @dragomirp in #1470

Bug fixes

• [DPE-8900] fix: harden pg_hba replication rules and ensure dynamic IP updates by @marceloneppel in #1506
• [DPE-9578] Check unit's host for restart need by @dragomirp in #1537
• [DPE-9706] Filter out users with no database by @dragomirp in #1555
• Bump snap to the latest security fixes by @taurus-forever in #1610
• [DPE-9443] Otel distribution cleanup by @dragomirp in #1532

COS (Otelcol / Grafana-agent)

Charmed PostgreSQL 14 is fully compatible and well tested with grafana-agent charm.
The new COS Otelcol (opentelemetry-collector) subordinate charm (rev256+) is compatible and open for testing/feedback.

Full Changelog: rev1044...rev1090

Revisions 1088, 1089

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

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Recommended Juju version
amd64	1089	283	16.13	3.6.21
arm64	1088	282	16.13	3.6.21

Features

• [DPE-9455] Bump PostgreSQL to 16.13 by @taurus-forever in #1509
• Bump snap to the latest security fixes by @taurus-forever in #1611
• [DPE-8932] Expose config parameters for pg_stat_statements by @dragomirp in #1420
• [DPE-9443] Switch to Ops tracing by @dragomirp in #1466
• [DPE-9451] Use socket for database observer and track members of relation access by @dragomirp in #1519

Bug fixes

• Bump snap to the latest security fixes by @taurus-forever in #1611
• Async replication upgrade fix and test tweaks by @dragomirp in #1511
• [DPE-9578] Check unit's host for restart need by @dragomirp in #1538

COS (Otelcol / Grafana-agent)

Charmed PostgreSQL 16 is fully compatible and well tested with grafana-agent charm.
The new COS Otelcol (opentelemetry-collector) subordinate charm (rev256+) is compatible and open for testing/feedback.

Full Changelog: v16/1.206.0...v16/1.242.0

Revisions 1044, 1045

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

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Min. recommended Juju version
amd64	1045	247	14.20	3.6.14+
arm64	1044	246	14.20	3.6.14+

Features

• [DPE-8932] Strict mode configuration by @dragomirp in #1395
• Multiple Patroni primaries alert by @Deezzir in #1459
• Speedup charm by parallel Patroni cluster call by @dragomirp in #1339
• Add optional flags to provides endpoints for PG14 VM by @taurus-forever in #1436

Bug fixes

• [DPE-9157] Patch shared buffers by @dragomirp in #1373
• [DPE-9150] Use socket for local connections by @dragomirp in #1364
• [MISC] Wait for TLS enablement before trying to restart by @dragomirp in #1392
• [DPE-8974] Handle certificate expiration by @dragomirp in #1394
• Add new stable releases to releases.md (14) by @a-velasco in #1406
• [DPE-9158] Limit repo listing to find the timelines by @dragomirp in #1404
• [DPE-9370] Handle retry error in bulk update by @dragomirp in #1426
• [DPE-9745] Check if bucket key is present by @dragomirp in #1465
• [DPE-5263] chore: bump charmed-postgresql snap revisions by @marceloneppel in #1471
• Revert COS agent lib (14/edge) by @dragomirp in #1474

Full Changelog: rev986...rev1044

Revisions 1046, 1047

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

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Min. recommended Juju version
amd64	1047	244	16.11	3.6.14+
arm64	1046	242	16.11	3.6.14+

Features

• Add multiple Patroni primaries alert by @Deezzir in #1460
• [DPE-8932] Strict mode configuration by @dragomirp in #1389
• [DPE-8980] Support Juju 4 (use '--force' to deploy) by @taurus-forever in #1318
• Add docs about custom usernames by @a-velasco in #1409
• Add optional flags to provides endpoints for PG16 VM by @taurus-forever in #1435

Bug fixes

• [DPE-9157] Patch shared buffers by @taurus-forever in #1374
• [DPE-9250] remove credentials on relation broken by @dragomirp in #1380
• [DPE-9158] Limit repo listing to find the timelines by @dragomirp in #1403
• [DPE-8900] Fix CIDR mask for self_ip (peer_ip in pg_hba) by @taurus-forever in #1424
• [DPE-9370] Handle retry error in bulk update by @dragomirp in #1427
• [DPE-9745] Check if bucket key is present by @dragomirp in #1462
• Revert COS agent lib (16/edge) by @dragomirp in #1472
• Revert fbfd2e8: DPE-9050 Give a try for Juju to 3.6.13 by @taurus-forever in #1381
• Update password management docs with Juju secrets (16) by @a-velasco in #1379

Full Changelog: v16/1.165.0...v16/1.206.0

Revisions 989, 990

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.11.

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Min. recommended Juju version
amd64	990	244	16.11	3.6.1+
arm64	989	242	16.11	3.6.1+

Highlights

• [DPE-9018] Bumped PostgreSQL to 16.11 by @taurus-forever in #1332
  • Check the official PostgreSQL 16.11 release notes
• [DPE-8860] New charm configs for worker process and WAL compression by @onkolahmet in #1284
• [DPE-7302] Ability to request database access by prefix by @dragomirp in #1238

Features

• [DPE-8987] Updated Juju Terraform Provider to 1.0.0 by @marceloneppel in #1319

Bug fixes

• [DPE-8615] Wait for storage to become available by @dragomirp in #1278
• [DPE-8975] Move PG16 VM TLS tests to 1/stable by @taurus-forever in #1314
• [DPE-9050 ] Temporary pin Juju to 3.6.11 by @taurus-forever in #1337
• [DPE-8865] Extract error messages by @marceloneppel in #1320
• [DPE-8747] Add integration test for persistent temp tablespace handling by @marceloneppel in #1347
• [DPE-9150] Use socket for local connections by @dragomirp in #1363
• Docs: fix db name in tutorial by @reneradoi in #1275
• Switch to config hash and pin last known working jammy image by @dragomirp in #1316
• Lock file maintenance Python dependencies (16/edge) by @renovate[bot] in #1326
• Update dependency uv to v0.9.14 (16/edge) by @renovate[bot] in #1324
• Use - instead of _ in error message by @carlcsaposs-canonical in #1340

Full Changelog: v16/1.135.0...v16/1.165.0

Revisions 986, 987

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

This release upgrades the PostgreSQL version to 14.20.

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Min. recommended Juju version
amd64	987	245	14.20	3.6.1+
arm64	986	243	14.20	3.6.1+

Highlights

• [DPE-9018] Bumped PostgreSQL version to 14.20 by @taurus-forever in #1331
  • Check the official PostgreSQL 14.20 release notes
• [DPE-8948] Added worker process and WAL compression configuration options by @onkolahmet in #1344
• [DPE-3589] PgBackrest Dashboard and improved alert rules by @Deezzir in #1191

Bug fixes

• [DPE-9001] Dynamic TLS flag in the Patroni helper by @dragomirp in #1362
• [DPE-8573] Cache _patroni property by @dragomirp in #1249
• [DPE-8550] Check juju version before removing revision by @dragomirp in #1214
• [DPE-8615] Wait for storage to become available by @dragomirp in #1277
• [DPE-8975] Move PG14 VM TLS tests to 1/stable by @taurus-forever in #1313
• [DPE-6762] Catch archive command timeout by @marceloneppel in #1328
• Update charmcraft.yaml build tools (main) by @renovate[bot] in #1322
• Lock file maintenance Python dependencies (main) by @renovate[bot] in #1323

New Contributors

• @Deezzir made their first contribution in #1191

Full Changelog: rev935...rev986

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

Revisions 935, 936

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

This release upgrades the PostgreSQL version to 14.19, and introduces several security and stability improvements.

System requirements | How to upgrade

Compatibility

Architecture	Charm revision	Snap version	PostgreSQL version	Minimum 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)
  • Check the official PostgreSQL 14.16, 14.17, 14.18, 14.19 release notes
• [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: rev552...rev935