Charmed PostgreSQL K8s Reference - Revision 73

Reference > Release Notes > All revisions > Revision 73

Revision 73

Thursday, April 20, 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. :tada:

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

  • Deploying on Kubernetes (tested with MicroK8s, GKE)
  • 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. “PostgreSQL Data Injector
  • Documentation

Inside the charms

  • Charmed PostgreSQL K8s charm ships the latest PostgreSQL “14.7-0ubuntu0.22.04.1”
  • 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

Compatibility with legacy charms:

  • 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.
  • Charm PostgreSQL K8s charm follows the SNAP track “14” (through repackaed ROCK/OCI image).
  • No “latest” track in use (no surprises in tracking “latest/stable”)!
    • Charmed PostgreSQL K8s charms provide legacy charm through “latest/stable”.
  • Charm lifecycle flowchart diagrams: PostgreSQL.
  • Modern interfaces are well described in “Interfaces catalogue” and implemented by ‘data-platform-libs’.
  • Known limitation: PostgreSQL extensions are not yet supported.

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.