Charmed PostgreSQL K8s Tutorial - Overview

Charmed PostgreSQL K8s tutorial

The Charmed PostgreSQL K8s Operator delivers automated operations management from day 0 to day 2 on the PostgreSQL relational database. It is an open source, end-to-end, production-ready data platform on top of Juju. As a first step this tutorial shows you how to get Charmed PostgreSQL K8s up and running, but the tutorial does not stop there. Through this tutorial you will learn a variety of operations, everything from adding replicas to advanced operations such as enabling Transport Layer Security (TLS). In this tutorial we will walk through how to:

  • Set up an environment using Multipass with MicroK8s and Juju.
  • Deploy PostgreSQL using a single command.
  • Access the database directly.
  • Add high availability with PostgreSQL Patroni-based cluster.
  • Request and change passwords.
  • Automatically create PostgreSQL users via Juju relations.
  • Reconfigure TLS certificate in one command.

While this tutorial intends to guide and teach you as you deploy Charmed PostgreSQL K8s, it will be most beneficial if you already have a familiarity with:

  • Basic terminal commands.
  • PostgreSQL concepts such as replication and users.

Step-by-step guide

Here’s an overview of the steps required with links to our separate tutorials that deal with each individual step:


The Charmed PostgreSQL K8s Operator is distributed under the Apache Software License, version 2.0. It installs/operates/depends on PostgreSQL, which is licensed under PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses…

Trademark Notice

PostgreSQL is a trademark or registered trademark of PostgreSQL Global Development Group. Other trademarks are property of their respective owners.