Charmed PostgreSQL K8s How-to guides

[avgomes (Andreia Velasco)]

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
• MicroK8s
• 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
  • Enable plugins/extensions

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