Charmed PostgreSQL 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 machines.

Deployment and setup

Installation of different cloud services with Juju:

• Sunbeam
• LXD
• MAAS
• AWS EC2
• GCE
• Azure
• Multi-availability zones (AZ)

Specific deployment scenarios and architectures:

• Terraform
• Air-gapped
• TLS VIP access

Usage and maintenance

• Integrate with another application
• External access
• Scale replicas
• Enable TLS
• 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
• Enable alert rules
• Enable tracing

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