Charmed PostgreSQL VM
- By Canonical Data Platform
- Databases
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| latest/stable | 345 | 09 Nov 2023 | |
| 14/stable | 363 | 21 Feb 2024 | |
| 14/candidate | 363 | 31 Jan 2024 | |
| 14/beta | 368 | 21 Feb 2024 | |
| 14/edge | 396 | 16 Apr 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
Charmed PostgreSQL VM Tutorial
This comprehensive, hands-on tutorial for Charmed PostgreSQL VM aims to provide an overview of the operations you can perform with this charm. You will be guided through each step in a controlled environment so that you can follow along on your own machine.
Requirements
While this tutorial intends to guide and teach you as you deploy Charmed PostgreSQL VM for the first time, it will be most beneficial if:
- You are familiar with basic terminal commands.
- You are familiar with PostgreSQL concepts such as replication and users.
- Your computer fulfils the minimum system requirements
Steps in this tutorial
This Charmed PostgreSQL VM tutorial has the following components:
| Step | Details |
|---|---|
| 1. Set up the environment | Set up an 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. Manage your units | 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 via integrations. |
| 6. Enable security | Learn how to enable security in your PostgreSQL deployment via TLS by integrating with the TLS Certificates Charm. |
| 7. Clean-up your environment |
Licence
The Charmed PostgreSQL Operator is distributed under the Apache Software Licence version 2.0. It depends on PostgreSQL, which is licensed under the PostgreSQL Licence, a liberal Open Source licence, similar to the BSD or MIT licences.
Trademark Notice
PostgreSQL is a trademark or registered trademark of PostgreSQL Global Development Group. Other trademarks are the property of their respective owners.