Charmed PostgreSQL VM

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 239 09 Feb 2022
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 226 01 Apr 2021
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable 430 28 Jun 2024
Ubuntu 22.04
14/stable 429 28 Jun 2024
Ubuntu 22.04
14/candidate 429 26 Jun 2024
Ubuntu 22.04
14/candidate 430 26 Jun 2024
Ubuntu 22.04
14/beta 430 26 Jun 2024
Ubuntu 22.04
14/beta 429 26 Jun 2024
Ubuntu 22.04
14/edge 436 10 Jul 2024
Ubuntu 22.04
14/edge 435 10 Jul 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
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. :tada:

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

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.

Help improve this document in the forum (guidelines). Last updated 2 months ago.