odoo-backup-strategy

name	odoo-backup-strategy
description	Complete Odoo backup and restore strategy: database dumps, filestore backup, automated scheduling, cloud storage upload, and tested restore procedures.
type	skill
created	2026-02-27T00:00:00.000Z
domain	productivity
category	developer-experience
risk	safe
source	self
tags	["skill","productivity","developer-experience","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

#!/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)