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 351
Revision 351
January 3, 2024
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
- [Core] Updated
Charmed PostgreSQL
SNAP image (PR#291)(DPE-3039):Patroni
updated from 3.0.2 to 3.1.2Pgbackrest
updated from 2.47 to 2.48
- [Plugins] Add 24 new plugins/extension in (PR#251)
- [Plugins] NOTE: extension
plpython3u
is deprecated and will be removed from list of supported plugins soon! - [Config] Add 29 new configuration options in (PR#239)(DPE-1781)
- [Config] NOTE: the config option
profile-limit-memory
is deprecated. Useprofile_limit_memory
(to follow the naming conventions)! (PR#306)(DPE-3096) - [Charm] Add Juju Secret labels in (PR#270)(DPE-2838)
- [Charm] Update Python dependencies in (PR#293)
- [DB] Add handling of tables ownership in (PR#298)(DPE-2740)
- (COS) Moved Grafana dashboard legends to the bottom of the graph in (PR#295)(DPE-2622)
- (COS) Add Patroni COS support (#261)(DPE-1993)
- [CI/CD] Charm migrated to GitHub Data reusable workflow in (PR#263)(DPE-2789)
- All the functionality from the previous revisions
Bugfixes
- Fixed enabling extensions when new database is created (PR#252)(DPE-2569)
- Block the charm if the legacy interface requests roles (DPE-3077)
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.2.1”
- Backup tools pgBackRest updated to “2.48”
- 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) revision 89
- Principal charms supports the latest LTS series “22.04” only
- Subordinate charms support LTS “22.04” and “20.04” only
Technical notes
- Upgrade (
juju refresh
) is possible from this revision 336+ - Use this operator together with a modern operator “pgBouncer”
- 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.