Odoo Backup Strategy: The Complete Disaster Recovery Playbook
A production database crash without a tested backup is every admin's nightmare. Here's your complete guide to Odoo backup strategies that actually work.
Inadequate backup practices are one of the most common findings in Odoo health scans. The most common scenario: daily backups are configured, but nobody has ever tested a restore. When disaster strikes, they discover the backups are corrupted, incomplete, or missing the filestore entirely.
The 3-2-1 Backup Rule for Odoo
The gold standard for backup is the 3-2-1 rule: 3 copies of your data, on 2 different media, with 1 offsite. For Odoo specifically, this means:
- Copy 1: Live database (PostgreSQL on the server)
- Copy 2: Automated daily backup to local storage
- Copy 3: Encrypted offsite backup (S3, GCS, or another provider)
What to Back Up
An Odoo backup has three components that must be captured together:
✅ Need evidence for your next compliance audit? NonaGuard generates comprehensive security reports that map directly to SOC 2 and GDPR control requirements.
- PostgreSQL database dump — Use
pg_dumpwith custom format for compressed, parallel-restorable backups - Filestore — The
~/.local/share/Odoo/filestore/directory contains all attachments, report templates, and uploaded files - Configuration — The
odoo.conffile and any custom addons paths
Automation with Cron
A reliable backup cron script should:
- Dump the database with compression
- Tar the filestore with the dump
- Encrypt the archive (GPG or OpenSSL)
- Upload to offsite storage
- Delete local backups older than 7 days
- Log success/failure and alert on errors
Testing Your Restores
The most critical step is routine restore testing. At minimum, do a full restore to a staging environment monthly. Verify:
- Database restores without errors
- Filestore attachments are accessible
- Custom modules load correctly
- Cron jobs resume properly
NonaGuard monitors your backup health indicators — checking for missing filestore synchronization, stale backup timestamps, and database size anomalies. Start your free scan.
📋 Generate Compliance Evidence
NonaGuard's scan reports serve as continuous evidence of security monitoring, permission auditing, and vulnerability management — exactly what auditors want to see.
