How-to guides

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

Deployment and setup

Available deployment methods, clouds, and specialised setups:

• Deploy

Operations and maintenance

Essential operations to configure and manage a PostgreSQL cluster:

• Scale
• Integrate
• Manage passwords
• Enable TLS
• Enable plugins/extensions

Advanced networking, credential management, and disaster recovery:

• External network access
• Enable LDAP
• Switchover/failover

Backups and data migration

Configuration of storage providers and backup management:

• Back up and restore
  • Configure S3 AWS
  • Configure S3 RadosGW
  • Create a backup
  • Restore a backup
  • Manage backup retention
  • Migrate a cluster

Monitoring (COS)

Set up observability services like Grafana, Prometheus, Loki, and Tempo through the Canonical Observability Stack (COS):

• Monitoring (COS)
  • Enable monitoring
  • Enable alert rules
  • Enable tracing
  • Enable profiling

Refresh (upgrade)

Instructions for performing an in-place application refresh:

• Refresh (upgrade)

Cross-regional (cluster-cluster) async replication

Walkthrough of a cluster-cluster deployment and its essential operations:

• Cross-regional async replication
  • Set up clusters
  • Integrate with a client app
  • Remove or recover a cluster

Charm development

For charm developers looking to support PostgreSQL integrations with their charm

• Development
  • Integrate with your charm
  • Migrate data via pg_dump
  • Migrate data via backup/restore