Revision 288

vm

The first stable of Charmed PostgreSQL for machines has been published in the 14/stable channel.

Charmhub • System requirements • How to deploy • All release notes

Highlights

  • 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”.

Full Changelog: https://github.com/canonical/postgresql-operator/commits/rev288

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

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!

Requirements

See the system requirements for more details about Juju versions and other software and hardware prerequisites.