How-to guides

The following guides cover key processes and common tasks for setting up and managing Charmed PostgreSQL on bare metal and virtual machines.

Deployment and setup

Available deployment methods and specialised setups:

Operations and maintenance

Essential operations to configure and manage a PostgreSQL cluster:

Advanced networking, credential management, and disaster recovery:

Backups and data migration

Configuration of storage providers and backup management for safety and data migration from a different cluster:

Other data migration guides:

Monitoring (COS)

Set up observability services like Grafana, Prometheus, Loki, and Tempo through the Canonical Observability Stack (COS):

Refresh (upgrade)

Instructions for performing an in-place application refresh:

Cross-regional (cluster-cluster) async replication

Walkthrough of a cluster-cluster deployment and its essential operations:

Logical replication

Replicate a subset of data to another PostgreSQL cluster:

Charm development

For charm developers looking to support PostgreSQL integrations with their charm

Other relevant guides: