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: