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 endpoints db and db-admin). However, it is highly recommended to migrate to the modern interface postgresql_client (endpoint database).
  • 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

• Raise software issues or feature requests on GitHub
• Report security issues through Launchpad
• Contact the Canonical Data Platform team through our Matrix channel!