Skip to main content

Backup & Restore

Protect your beekeeping data with reliable backup and restore procedures.

Automated Backups​

Database Backups​

#!/bin/bash
# backup-db.sh
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_DIR="/backups/database"
mkdir -p $BACKUP_DIR

# PostgreSQL backup
pg_dump -U postgres hivepal | gzip > $BACKUP_DIR/hivepal_$DATE.sql.gz

# Cleanup old backups (keep 30 days)
find $BACKUP_DIR -name "*.sql.gz" -mtime +30 -delete

File Backups​

#!/bin/bash  
# backup-files.sh
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_DIR="/backups/files"
UPLOAD_DIR="/var/lib/hive-pal/uploads"

mkdir -p $BACKUP_DIR
tar -czf $BACKUP_DIR/uploads_$DATE.tar.gz -C $UPLOAD_DIR .

Cron Scheduling​

# Add to crontab
crontab -e

# Database backup daily at 2 AM
0 2 * * * /scripts/backup-db.sh

# File backup daily at 3 AM  
0 3 * * * /scripts/backup-files.sh

# Weekly full backup
0 1 * * 0 /scripts/backup-full.sh

Manual Backups​

Database Export​

# Full database
pg_dump -U postgres -h localhost hivepal > backup.sql

# Schema only
pg_dump -U postgres -h localhost --schema-only hivepal > schema.sql

# Data only
pg_dump -U postgres -h localhost --data-only hivepal > data.sql

Specific Tables​

# Backup specific tables
pg_dump -U postgres -h localhost -t users -t apiaries hivepal > partial.sql

Files Export​

# Copy upload directory
cp -r /var/lib/hive-pal/uploads /backups/uploads_backup

# Create compressed archive
tar -czf uploads_backup.tar.gz uploads/

Docker Backups​

Container Data​

# Database container backup
docker-compose exec postgres pg_dump -U postgres hivepal > backup.sql

# Volume backup
docker run --rm -v hive-pal_postgres_data:/data -v $(pwd):/backup alpine tar czf /backup/postgres_data.tar.gz /data

Full Stack Backup​

# Stop containers
docker-compose down

# Backup volumes
docker run --rm -v hive-pal_postgres_data:/postgres -v hive-pal_uploads:/uploads -v $(pwd):/backup alpine tar czf /backup/full_backup.tar.gz /postgres /uploads

# Restart
docker-compose up -d

Restore Procedures​

Database Restore​

# Drop and recreate database
dropdb -U postgres hivepal
createdb -U postgres hivepal

# Restore from backup
psql -U postgres hivepal < backup.sql

# Or from compressed backup
gunzip -c backup.sql.gz | psql -U postgres hivepal

Partial Restore​

# Restore specific tables
psql -U postgres hivepal < partial_backup.sql

# Restore with conflict handling
psql -U postgres hivepal -c "TRUNCATE TABLE users CASCADE;"
psql -U postgres hivepal < users_backup.sql

File Restore​

# Restore uploads directory
rm -rf /var/lib/hive-pal/uploads
tar -xzf uploads_backup.tar.gz -C /var/lib/hive-pal/

# Set permissions
chown -R hive-pal:hive-pal /var/lib/hive-pal/uploads
chmod -R 755 /var/lib/hive-pal/uploads

Docker Restore​

# Stop containers
docker-compose down

# Restore volumes
docker run --rm -v hive-pal_postgres_data:/data -v $(pwd):/backup alpine tar xzf /backup/postgres_data.tar.gz -C /

# Start containers
docker-compose up -d

# Run migrations if needed
docker-compose exec backend npm run migrate

Cloud Backups​

AWS S3​

# Install AWS CLI
aws configure

# Upload backup
aws s3 cp backup.sql.gz s3://your-backup-bucket/hive-pal/$(date +%Y%m%d)/

# Download backup
aws s3 cp s3://your-backup-bucket/hive-pal/20241201/backup.sql.gz .

Google Cloud Storage​

# Install gcloud
gcloud auth login

# Upload
gsutil cp backup.sql.gz gs://your-backup-bucket/hive-pal/

# Download  
gsutil cp gs://your-backup-bucket/hive-pal/backup.sql.gz .

Monitoring Backups​

Backup Verification​

#!/bin/bash
# verify-backup.sh

# Check if backup file exists and is recent
BACKUP_FILE="/backups/database/$(date +%Y%m%d)_*.sql.gz"
if [ ! -f $BACKUP_FILE ]; then
    echo "ERROR: No backup found for today"
    exit 1
fi

# Check backup file size
SIZE=$(stat -f%z $BACKUP_FILE 2>/dev/null || stat -c%s $BACKUP_FILE)
if [ $SIZE -lt 1000000 ]; then  # Less than 1MB
    echo "WARNING: Backup file seems too small"
fi

echo "Backup verification complete"

Automated Testing​

# Test restore process
createdb test_restore
gunzip -c backup.sql.gz | psql test_restore
dropdb test_restore

Disaster Recovery​

Recovery Planning​

  1. Identify critical data
  2. Set recovery time objectives (RTO)
  3. Set recovery point objectives (RPO)
  4. Document procedures
  5. Test regularly

Emergency Procedures​

# Quick restore checklist
# 1. Stop application
sudo systemctl stop hive-pal

# 2. Restore database
dropdb hivepal && createdb hivepal
psql hivepal < latest_backup.sql

# 3. Restore files
tar -xzf latest_files_backup.tar.gz -C /var/lib/hive-pal/

# 4. Start application
sudo systemctl start hive-pal

Best Practices​

Backup Strategy​

  • 3-2-1 Rule: 3 copies, 2 different media, 1 offsite
  • Regular schedule: Daily database, weekly files
  • Test restores: Monthly verification
  • Monitor success: Automated alerts

Security​

  • Encrypt backup files
  • Secure storage locations
  • Access control
  • Audit backup access

Documentation​

  • Keep recovery procedures updated
  • Document backup locations
  • Maintain restore checklists
  • Train team members

Automation​

  • Use configuration management
  • Monitor backup jobs
  • Alert on failures
  • Verify backup integrity