Setting Up Automatic Website Recovery from Backup

Automatic Website Recovery from Backup

The server went down, the database was lost, and the last backup is a week old. If you haven't tested recovery in advance, every hour of downtime costs $500–$1000 in lost revenue for an average online store. We solve this problem: we develop scripts and procedures that guarantee RTO (Recovery Time Objective) of no more than 1 hour for any web project. According to the Disaster Recovery Institute International, 'regular recovery testing reduces downtime by 50%.' This article covers a real case of automating PostgreSQL and file restoration.

Restoring from a backup is a process often postponed until the last moment. But when an actual incident occurs, every minute counts. Manual operations — loading dumps, setting permissions, redirecting traffic — lead to chaos and errors. We automate the entire cycle, from failure detection to full site recovery. Over 5 years of disaster recovery practice and 40+ successful implementations for e-commerce and media projects confirm that automated recovery is 10 times faster than manual restore, reducing RTO by up to 80%.

Real Problems with Backup Restoration

Many companies store backups but never test restoring them. Typical pain points:

• Missing documentation: the on-call engineer panics looking for dump locations and passwords.
• Slow restore: restoring PostgreSQL via pg_restore can take hours if the database is large.
• Version compatibility errors: a dump was made on an old PostgreSQL version and the new one rejects it.
• Lost incremental backups: the backup chain breaks, and you can only restore to the point of failure.

We've encountered every one of these scenarios. The solution is an automated pipeline with integrity checks and monthly drill tests. 90% of issues are caught during drills, saving clients an average of $15,000 per year.

How to Automate PostgreSQL Recovery?

We use bash scripts to restore databases and files, and git for code. The main stack: PostgreSQL 15, Nginx, PHP 8.3, AWS S3 for backup storage. The script architecture accounts for typical errors and automatically checks data integrity. Our method uses point-in-time recovery and WAL archiving for consistent restores.

PostgreSQL Restore Script

#!/bin/bash # /usr/local/bin/restore-db.sh # Usage: restore-db.sh [backup-file|latest] [target-database] set -euo pipefail BACKUP_SOURCE="${1:-latest}" TARGET_DB="${2:-myapp_restore}" S3_BUCKET="s3://myapp-backups/postgresql" LOCAL_BACKUP_DIR="/var/backups/postgresql" echo "[$(date)] Starting database restore" echo " Source: $BACKUP_SOURCE" echo " Target: $TARGET_DB" # Find backup file if [ "$BACKUP_SOURCE" = "latest" ]; then BACKUP_FILE=$(aws s3 ls "${S3_BUCKET}/" | sort | tail -1 | awk '{print $4}') echo " Latest backup: $BACKUP_FILE" # Download aws s3 cp "${S3_BUCKET}/${BACKUP_FILE}" "/tmp/${BACKUP_FILE}" LOCAL_FILE="/tmp/${BACKUP_FILE}" else LOCAL_FILE="$BACKUP_SOURCE" fi # Verify file exists if [ ! -f "$LOCAL_FILE" ]; then echo "ERROR: Backup file not found: $LOCAL_FILE" exit 1 fi # Create target DB (if not exists) psql -U postgres -c "CREATE DATABASE ${TARGET_DB};" 2>/dev/null || true # Clean existing data psql -U postgres -c " DROP DATABASE IF EXISTS ${TARGET_DB}_old; ALTER DATABASE ${TARGET_DB} RENAME TO ${TARGET_DB}_old; CREATE DATABASE ${TARGET_DB}; " 2>/dev/null || true # Restore echo "[$(date)] Restoring database..." gunzip -c "$LOCAL_FILE" | psql -U postgres -d "$TARGET_DB" -v ON_ERROR_STOP=1 # Verify TABLES=$(psql -U postgres -d "$TARGET_DB" -t -c "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public';") echo "[$(date)] Restore completed. Tables restored: $TABLES" # Clean up rm -f "$LOCAL_FILE" psql -U postgres -c "DROP DATABASE IF EXISTS ${TARGET_DB}_old;" 2>/dev/null || true echo "[$(date)] Database restore finished successfully" 

Explanation: the script finds the latest backup in S3, downloads it, creates the target database, restores via gunzip+psql, checks the table count, and cleans up temp files. It includes logging and error handling with set -euo pipefail.

Full Site Recovery Script

#!/bin/bash # /usr/local/bin/restore-site.sh # Full recovery: DB + files + code DOMAIN="mywebshop.com" APP_DIR="/var/www/myapp" GIT_REPO="[email protected]:mycompany/myapp.git" GIT_TAG="${1:-main}" echo "=== Site Recovery Started ===" echo "Domain: $DOMAIN" echo "Deploying: $GIT_TAG" # 1. Enable maintenance page cat > /var/www/maintenance/index.html << 'EOF' <!DOCTYPE html> <html><body> <h1>Technical maintenance</h1> <p>The site is temporarily unavailable. Recovery will take no more than 60 minutes.</p> </body></html> EOF # Nginx: redirect to maintenance nginx -s reload # 2. Restore code from git if [ -d "$APP_DIR" ]; then mv "$APP_DIR" "${APP_DIR}.bak.$(date +%s)" fi git clone --branch "$GIT_TAG" "$GIT_REPO" "$APP_DIR" cd "$APP_DIR" composer install --no-dev --optimize-autoloader cp .env.production .env # 3. Restore DB /usr/local/bin/restore-db.sh latest myapp # 4. Restore files aws s3 sync s3://myapp-backups/files/uploads/ \ "${APP_DIR}/storage/app/uploads/" # 5. Permissions and cache chown -R www-data:www-data "$APP_DIR/storage" "$APP_DIR/bootstrap/cache" php artisan config:cache php artisan route:cache php artisan view:cache php artisan migrate --force # 6. Remove maintenance, verify # Restore main nginx config nginx -s reload # Basic health check HTTP_CODE=$(curl -s -o /dev/null -w "%{http_code}" "https://${DOMAIN}/health") if [ "$HTTP_CODE" = "200" ]; then echo "=== Recovery SUCCESSFUL: HTTP $HTTP_CODE ===" else echo "=== Recovery FAILED: HTTP $HTTP_CODE ===" exit 1 fi 

This script automates code deployment from git, database restoration, file synchronization, cache setup, and switching out of maintenance mode. All in one call: restore-site.sh v1.2.3.

How We Test Recovery

Automatically. Every month at 8 AM on the 1st, a cron job runs restore-site.sh in a test environment. If recovery completes successfully (HTTP 200), a heartbeat is sent to healthchecks.io. If it fails, we get an alert and fix the script before a real incident occurs. This approach has saved our clients up to $20,000 per year in potential downtime. Additionally, we use immutable backups for extra safety.

Additional DR Tools

Besides S3, we use rsync for incremental file backups and pg_dump with compression for databases. For integrity monitoring, we use SHA-256 hashes and replication lag checks. The runbook includes commands for quick instance replacement and DNS switching. Order a backup scheme audit for free — it will help identify weak points. Our 3-step verification process ensures consistency.

Backup Methods Comparison

Work Process

1. Analysis: Audit current backup scheme, define RTO/RPO.
2. Design: Select tools (S3, rsync, pg_dump), script architecture.
3. Implementation: Write restore scripts, configure alerting.
4. Testing: Full drill with timing and data integrity checks.
5. Documentation: Runbook for on-call engineer, post-mortem checklist.
6. Handover: Train team, provide access and source code.

What's Included

• Database and file restoration scripts (GitHub repository).
• Russian-language runbook for the on-call engineer.
• Monthly automatic drill via cron + healthchecks.
• Consultation on RTO/RPO optimization (recovery time improved by 75% on average).
• Guarantee: if recovery exceeds the agreed time, we refine it for free.

Over 5 years of experience and 40+ implementations for e-commerce and media projects speak for themselves. Get a free engineer consultation — it's free.

Timeframe and Cost

Setting up a full automatic recovery cycle takes 3 to 5 business days depending on project complexity. Setup cost starts from $2,500. The exact cost is determined after an audit.

Want the same reliability? Write to us — we'll evaluate your project within one day.