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
14/stable 363 21 Feb 2024
Ubuntu 22.04
14/candidate 363 31 Jan 2024
Ubuntu 22.04
14/beta 368 21 Feb 2024
Ubuntu 22.04
14/edge 401 26 Apr 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
22.04

Charmed PostgreSQL VM Tutorial

This section of our documentation contains comprehensive, hands-on tutorials to help you learn how to deploy Charmed PostgreSQL K8s and become familiar with its available operations.

Prerequisites

While this tutorial intends to guide you as you deploy Charmed PostgreSQL K8s for the first time, it will be most beneficial if:

  • You have some experience using a Linux-based CLI
  • You are familiar with PostgreSQL concepts such as replication and users.
  • Your computer fulfills the minimum system requirements

Tutorial contents

This Charmed PostgreSQL tutorial has the following parts:

Step Details
1. Set up the environment Set up a cloud environment for your deployment using Multipass with LXD and Juju.
2. Deploy PostgreSQL Learn to deploy Charmed PostgreSQL K8s using a single command and access the database directly.
3. Scale the amount of replicas Learn how to enable high availability with a Patroni-based cluster.
4. Manage passwords Learn how to request and change passwords.
5. Integrate your PostgreSQL with other applications Learn how to integrate with other applications using the Data Integrator Charm, access the integrated database, and manage users.
6. Enable TLS encryption Learn how to enable security in your PostgreSQL deployment via TLS.
7. Clean-up your environment Free up your machine’s resources.