Charmed PostgreSQL K8s
- By Canonical Data Platform
- Databases
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| latest/stable | 20 | 20 Sep 2022 | |
| 14/stable | 193 | 13 Mar 2024 | |
| 14/candidate | 193 | 31 Jan 2024 | |
| 14/beta | 211 | 13 Mar 2024 | |
| 14/edge | 237 | 16 Apr 2024 |
juju deploy postgresql-k8s --channel 14/stable
Deploy Kubernetes operators easily with Juju, the Universal Operator Lifecycle Manager. Need a Kubernetes cluster? Install MicroK8s to create a full CNCF-certified Kubernetes system in under 60 seconds.
Platform:
Reference > Release Notes > All revisions > Revision 158
Revision 158
Wednesday, October 18, 2023
Dear community,
We’d like to announce that Canonical’s newest Charmed PostgreSQL operator for Kubernetes 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-1372]
- Profiles configuration support [DPE-2656]
- Logs rotation [DPE-1755]
- 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
Canonical Data issues are now public on both Jira and GitHub platforms.
GitHub Releases provide a detailed list of bugfixes/PRs/Git commits for each revision.
Highlights for the current revision:
- DPE-1470, DPE-2419 Fixed K8s resources cleanup
- DPE-1584 Backup/restore stabilization bugfixes
- DPE-2546 Split stanza create and stanza check (backup stabilization)
- DPE-2626, DPE-2627 Create bucket once and clear up blocked statuses (backup stabilization)
- DPE-2657 Fix replication after restore
- DPE-1590 Fixed deployment on old microk8s (e.g. 1.22)
- DPE-2193 Fixed databases access to requested db only
- DPE-1999 Fixed TLS race condition in new relations (stuck in ‘awaiting for cluster to start’/‘awaiting for member to start’)
- DPE-2338 Use SCRAM by default
- DPE-2616 Auto-tune profile
production(mimic defaults of the legacy charm) - DPE-2569 Set waiting status while extensions are being enabled
- DPE-2015, DPE-2044 Add missing zoneinfo
Inside the charms
- Charmed PostgreSQL K8s 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”
- K8s charms based on our ROCK OCI (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 refreshfrom the old-stable revision 73 to the current-revision 158 is NOT supported!!!
The upgrade functionality is new and supported for revision 158+ only!- Please check the external components requirements
- Please check additionally the previously posted restrictions.
Contact us
Charmed PostgreSQL K8s 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.