How-to guides

The following guides cover key processes and common tasks for setting up and managing Charmed PostgreSQL on Kubernetes.

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: