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 468 11 Sep 2024
Ubuntu 22.04
14/stable 467 11 Sep 2024
Ubuntu 22.04
14/candidate 468 02 Sep 2024
Ubuntu 22.04
14/candidate 467 02 Sep 2024
Ubuntu 22.04
14/beta 468 02 Sep 2024
Ubuntu 22.04
14/beta 467 02 Sep 2024
Ubuntu 22.04
14/edge 491 Yesterday
Ubuntu 22.04
14/edge 490 Yesterday
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
22.04 20.04 18.04 16.04 14.04

Charmed PostgreSQL Tutorial

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

Prerequisites

While this tutorial intends to guide you as you deploy Charmed PostgreSQL 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 fulfils 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 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 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.