Backup & Recovery

Backup Strategies

Database Backup

# PostgreSQL backup
pg_dump -h localhost -U fabconnect fabconnect > backup.sql

# Compressed backup
pg_dump -h localhost -U fabconnect fabconnect | gzip > backup.sql.gz

Configuration Backup

# Backup config files
tar -czvf config-backup.tar.gz /etc/fabconnect/

Automated Backups

backup:
  enabled: true
  schedule: "0 2 * * *"  # Daily at 2 AM
  retention: 30d
  destination:
    type: s3
    bucket: fabconnect-backups
    region: us-west-2

Recovery

Database Restore

# Restore from backup
psql -h localhost -U fabconnect fabconnect < backup.sql

# Restore from compressed
gunzip -c backup.sql.gz | psql -h localhost -U fabconnect fabconnect

Point-in-Time Recovery

Enable WAL archiving for PITR capability.