Charmed PostgreSQL K8s

Channel Revision Published Runs on
latest/stable 20 20 Sep 2022
Ubuntu 20.04
14/stable 73 18 Apr 2023
Ubuntu 22.04
14/candidate 139 19 Sep 2023
14/beta 145 26 Sep 2023
14/edge 150 Today
juju deploy postgresql-k8s --channel 14/stable
Show information


Charmed PostgreSQL K8s revision 73

Thursday, April 20, 2023

Dear community, this is to inform you that new Canonical Charmed PostgreSQL K8s charm is published in 14/stable charmhub channel for Kubernetes.

The 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:
Charm Version Charm channel Documentation License
PostgreSQL K8s 14.7 14/stable (r73) Tutorial, Readme, Contributing Apache 2.0

What is 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:

  • 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, see details below, if you are considering migrating from other “legacy” charms not mentioned above. Additionally:

  • Tracks description:
    • 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.

How to reach us:

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report. Contribute to the project!


The document was originally posted here.

Help us improve this documentation

Most of this documentation can be collaboratively discussed and changed on the respective topic in the doc category of the Charmhub forum. See the documentation guidelines if you’d like to contribute.

Last updated 12 days ago. Help improve this document in the forum.