Charmed PostgreSQL VM
- By Canonical Data Platform
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 345 | 09 Nov 2023 | |
latest/stable | 239 | 09 Feb 2022 | |
latest/stable | 226 | 01 Apr 2021 | |
14/stable | 430 | 28 Jun 2024 | |
14/stable | 429 | 28 Jun 2024 | |
14/candidate | 468 | 02 Sep 2024 | |
14/candidate | 467 | 02 Sep 2024 | |
14/beta | 468 | 02 Sep 2024 | |
14/beta | 467 | 02 Sep 2024 | |
14/edge | 472 | Yesterday | |
14/edge | 471 | Yesterday |
juju deploy postgresql --channel 14/edge
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
Reference > Release Notes > All revisions > Revision 336
Revision 336
Wednesday, October 18, 2023
Dear community,
We’d like to announce that Canonical’s newest Charmed PostgreSQL operator for IAAS/VM has been published in the 14/stable
channel.
If you are jumping over several stable revisions, make sure to check previous release notes before upgrading to this revision.
Features you can start using today
- Add Juju 3 support (Juju 2 is still supported) [DPE-1758]
- All secrets are now stored in Juju secrets [DPE-1758]
- Charm minor upgrades and minor rollbacks [DPE-1767]
- Canonical Observability Stack (COS) support [DPE-1775]
- PostgreSQL plugins support [DPE-1373]
- Profiles configuration support [DPE-2655]
- Logs rotation [DPE-1754]
- Workload updated to PostgreSQL 14.9 [PR#18]
- Add ‘
admin
’ extra user role [DPE-2167] - New charm ‘PostgreSQL Test App’
- New documentation:
- All the functionality from the previous revisions
Bugfixes
- DPE-1624, DPE-1625 Backup/restore fixes
- DPE-1926 Remove fallback_application_name field from relation data
- DPE-1712 Enabled the user to fix network issues and rerun stanza related hooks
- DPE-2173 Fix allowed units relation data field
- DPE-2127 Fixed databases access
- DPE-2341 Populate extensions in unit databag
- DPE-2218 Update charm libs to get s3 relation fix
- DPE-1210, DPE-2330, DPE-2212 Open port (ability to expose charm)
- DPE-2614 Split stanza create and stanza check
- DPE-2721 Allow network access for pg_dump, pg_dumpall and pg_restore
- DPE-2717 Copy dashboard changes from K8s and use the correct topology dispatcher
- [MISC] Copy fixes of DPE-2626 and DPE-2627 from k8s
- [MISC] Don’t fail if the unit is already missing
- [MISC] More resilient topology observer
Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bugfixes, PRs, and commits for each revision.
Inside the charms
- Charmed PostgreSQL ships the latest PostgreSQL “14.9-0ubuntu0.22.04.1”
- PostgreSQL cluster manager Patroni updated to “3.0.2”
- Backup tools pgBackRest updated to “2.47”
- The Prometheus postgres-exporter is “0.12.1-0ubuntu0.22.04.1~ppa1”
- VM charms based on Charmed PostgreSQL SNAP (Ubuntu LTS “22.04” - ubuntu:22.04-based)
- Principal charms supports the latest LTS series “22.04” only.
- Subordinate charms support LTS “22.04” and “20.04” only.
Technical notes
juju refresh
from the old-stable revision 288 to the current-revision 324 is NOT supported!!!
The upgrade functionality is new and supported for revision 324+ only!- Please check additionally the previously posted restrictions.
- Ensure the charm requirements met
Contact us
Charmed PostgreSQL is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.
- Raise software issues or feature requests on GitHub
- Report security issues through Launchpad
- Contact the Canonical Data Platform team through our Matrix channel.