How-to guides

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

Deployment and setup

Installation of different cloud services with Juju:

• Canonical K8s

• GKE

• EKS

• AKS

• Multi-availability zones (AZ)

Other deployment scenarios and configurations:

• Terraform

• Air-gapped

Usage and maintenance

• Integrate with another application

• External access

• Scale replicas

• Enable TLS

• Enable LDAP

• Enable plugins/extensions

Backup and restore

• Configure S3 AWS

• Configure S3 RadosGW

• Create a backup

• Restore a backup

• Manage backup retention

• Migrate a cluster

Monitoring (COS)

• Enable monitoring with Grafana

• Enable alert rules with Prometheus

• Enable tracing with Parca

Minor upgrades

• Perform a minor upgrade

• Perform a minor rollback

Cross-regional (cluster-cluster) async replication

• Cross-regional async replication

  • Set up clusters

  • Integrate with a client app

  • Remove or recover a cluster

Development

This section is for charm developers looking to support PostgreSQL integrations with their charm.

• Integrate with your charm

• Migrate data via pg_dump

• Migrate data via backup/restore