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 516 19 Nov 2024
Ubuntu 22.04
14/beta 515 19 Nov 2024
Ubuntu 22.04
14/edge 518 19 Nov 2024
Ubuntu 22.04
14/edge 517 19 Nov 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/edge
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 your environment Set up a cloud environment for your deployment using Multipass with LXD and Juju.
2. Deploy PostgreSQL Learn to deploy Charmed PostgreSQL with Juju
3. Access PostgreSQL Access a PostgreSQL instance directly
4. Scale your replicas Learn how to enable high availability with a Patroni-based cluster.
5. Manage passwords Learn how to request and change passwords.
6. Integrate PostgreSQL with other applications Learn how to integrate with other applications using the Data Integrator charm, access the integrated database, and manage users.
7. Enable TLS encryption Learn how to enable security in your PostgreSQL deployment via TLS.
8. Clean up your environment Free up your machine’s resources.