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. |