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 | 468 | 11 Sep 2024 | |
14/stable | 467 | 11 Sep 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 | 482 | 27 Sep 2024 | |
14/edge | 481 | 27 Sep 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
22.04
20.04
18.04
16.04
14.04
Reference > Release Notes > All revisions > Revision 288
Revision 288
Thursday, April 20, 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.
Features you can start using today
- Deploying on VM (tested with LXD, MAAS)
- Scaling up/down in one simple juju command
- HA using Patroni
- Full backups and restores are supported when using any S3-compatible storage
- TLS support (using “tls-certificates” operator)
- DB access outside of Juju using “data-integrator”
- Data import using standard tools e.g. “psql”.
- Documentation:
Inside the charms:
- Charmed PostgreSQL charm ships the latest PostgreSQL “14.7-0ubuntu0.22.04.1”
- VM charms based on our SNAP (Ubuntu LTS “22.04” - core22-based)
- Principal charms supports the latest LTS series “22.04” only.
- Subordinate charms support LTS “22.04” and “20.04” only.
Technical notes
- The new PostgreSQL charm is also a juju interface-compatible replacement for legacy PostgreSQL charms (using legacy interface
pgsql
, via endpointsdb
anddb-admin
). However, it is highly recommended to migrate to the modern interfacepostgresql_client
(endpointdatabase
).- Please contact us if you are considering migrating from other “legacy” charms not mentioned above.
- Charmed PostgreSQL follows SNAP track “14”.
- No “latest” track in use (no surprises in tracking “latest/stable”)!
- PostgreSQL charm provide legacy charm through “latest/stable”.
- You can find charm lifecycle flowchart diagrams here.
- Modern interfaces are well described in the Interfaces catalogue and implemented by
data-platform-libs
. - Known limitation: PostgreSQL extensions are not yet supported.
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!