odoo-backup-strategy

# Odoo Backup Strategy ## Overview A complete Odoo backup must include both the **PostgreSQL database** and the **filestore** (attachments, images). This skill covers manual and automated backup procedures, offsite storage, and the correct restore sequence to bring a down Odoo instance back online. ## When to Use This Skill - Setting up a backup strategy for a production Odoo instance. - Automating daily backups with shell scripts and cron. - Restoring Odoo after a server failure or data corruption event. - Diagnosing a failed backup or corrupt restore. ## How It Works 1. **Activate**: Mention `@odoo-backup-strategy` and describe your server environment. 2. **Generate**: Receive a complete backup script tailored to your setup. 3. **Restore**: Get step-by-step restore instructions for any failure scenario. ## Examples ### Example 1: Manual Database + Filestore Backup ```bash #!/bin/bash # backup_odoo.sh DATE=$(date +%Y%m%d_%H%M%S) DB_NAME="odoo" DB_USER="odoo" FILESTORE_PATH="/var/lib/odoo/.local/share/Odoo/filestore/$DB_NAME" BACKUP_DIR="/backups/odoo" mkdir -p "$BACKUP_DIR" # Step 1: Dump the database pg_dump -U $DB_USER -Fc $DB_NAME > "$BACKUP_DIR/db_$DATE.dump" # Step 2: Archive the filestore tar -czf "$BACKUP_DIR/filestore_$DATE.tar.gz" -C "$FILESTORE_PATH" . echo "✅ Backup complete: db_$DATE.dump + filestore_$DATE.tar.gz" ``` ### Example 2: Automate with Cron (daily at 2 AM) ```bash # Run: crontab -e # Add this line: 0 2 * * * /opt/scripts/backup_odoo.sh ...