Database Backup Procedures¶
Guidelines for backing up and restoring the PostgreSQL database.
Automated Backups¶
Daily backups via cron:
# /etc/cron.daily/pg-backup
#!/bin/bash
pg_dump -U arctyk_user arctyk_db | gzip > /backups/arctyk_$(date +%Y%m%d).sql.gz