Backup & Recovery

Backup & Recovery

Protect your FlightStack data with regular backups.

What to Backup

• PostgreSQL database - All configuration, pipelines, runs
• Artifacts (if using local storage) - Build outputs
• Configuration - .env file, secrets

Database Backup

Manual Backup

# Docker
docker-compose exec postgres pg_dump -U flightstack flightstack > backup.sql

# Direct
pg_dump -h localhost -U flightstack flightstack > backup.sql

Restore

psql -h localhost -U flightstack flightstack < backup.sql

Automated Backups

Set up a cron job:

0 2 * * * pg_dump -h localhost -U flightstack flightstack > /backups/flightstack-$(date +\%Y\%m\%d).sql

Artifact Backup

If using local storage, backup the artifacts directory:

tar -czf artifacts-backup.tar.gz /var/flightstack/artifacts

Disaster Recovery

1. Provision new infrastructure
2. Restore PostgreSQL from backup
3. Restore artifacts
4. Update DNS to point to new instance
5. Re-register build agents