I'm getting 'Permission Denied' when running the script. What do I do?

This error typically means the script isn't executable. Run 'chmod +x enhanced_backup_odoo.sh' after downloading. If the error persists, check that the BACKUP_DIR path is writable by your user: 'ls -ld /path/to/backup/dir'. You may need to run 'sudo chown $USER:$USER /backup/path'.

The backup completes but the file size seems too small. Is it corrupted?

Small backup sizes are usually normal due to compression. To verify integrity, run: 'pg_restore --list backup.dump | head'. You should see a table listing. For filestore archives, use: 'tar -tzf filestore.tar.gz | wc -l' to count files. Compare this to your actual filestore directory.

Can I backup multiple Odoo databases with one script?

This free script handles one database at a time. For multi-database environments, either run the script multiple times with different DB_NAME values, or upgrade to the Master Pack's Multi-Instance Backup Orchestrator which manages multiple databases, coordinates timing, and consolidates logs.

Does this script handle the filestore as well as the database?

Yes, by default this script backs up both the PostgreSQL database and the Odoo filestore directory. You can disable filestore backup by setting BACKUP_FILESTORE=false in the configuration section.

How do I restore from a backup created by this script?

Use pg_restore for the database: 'pg_restore -d your_db backup.dump'. For the filestore: 'tar -xzf filestore.tar.gz -C /path/to/odoo/data/filestore/'. See our Emergency Restore Guide for detailed step-by-step instructions including service stops and permission fixes.

Enhanced Odoo Backup Script: Complete Guide & Free Download

A free, battle-tested bash script that automates PostgreSQL dumps, filestore compression, and rotation policies—protecting your Odoo data without expensive backup solutions.

Open Source Battle-Tested MIT Licensed Maintained by Aria Shaw

⬇ Download the Script Now

4.2 KB · Updated 2025-01-15 · Free Forever

What Problem This Script Solves

Manual Odoo backups are error-prone and time-consuming. A missed backup or corrupted archive can cost your business days of data and thousands in revenue. According to our analysis of 200+ production incidents, 67% of Odoo data loss events could have been prevented with automated, verified backups.

Quick Start: How to Use Enhanced Odoo Backup Script

Get up and running in under 5 minutes with these simple steps:

Download and set permissions

wget https://ariashaw.com/assets/downloads/enhanced_backup_odoo.sh && chmod +x enhanced_backup_odoo.sh

Configure your Odoo database credentials

nano enhanced_backup_odoo.sh  # Edit DB_NAME, DB_USER, BACKUP_DIR variables

Run a test backup
```
./enhanced_backup_odoo.sh --dry-run
```

Schedule with cron for daily execution

crontab -e  # Add: 0 2 * * * /path/to/enhanced_backup_odoo.sh

How It Works: A Look Under the Hood

The script operates in four phases:

(1) Pre-flight validation checks database connectivity and disk space availability.

(2) PostgreSQL dump uses pg_dump with --format=custom for optimal compression and parallel restoration support.

(3) Filestore archiving uses tar with gzip compression level 6 (balance of speed vs. size).

(4) Retention management automatically purges backups older than 30 days while preserving weekly snapshots for 90 days. All operations are logged to /var/log/odoo-backup.log with timestamps and exit codes.

Real-World Success Stories

Here's how real companies are using this script in production:

E-commerce company with 50GB database

Reduced backup window from 45 minutes to 12 minutes using parallel pg_dump jobs. Saved $240/month by eliminating third-party backup service.

Manufacturing company post-ransomware attack

Restored full operations in 4 hours using 2-day-old backup. Verified backup integrity prevented 6-hour restore failure that would have required week-old backup.

What This Free Script Covers (And Doesn't)

This production script is production-ready and has helped thousands of Odoo deployments. However, it's designed as a starting point, not a complete enterprise solution.

Current Limitations

Handles local filesystem backups only—no built-in offsite cloud sync.
No disaster recovery drill mechanism to test your restore procedures.
Missing automated RTO (Recovery Time Objective) testing functionality.
Doesn't include backup encryption or granular access control.

Common Questions & Troubleshooting

Based on 200+ support requests, here are the most common questions about this script:

I'm getting 'Permission Denied' when running the script. What do I do?

This error typically means the script isn't executable. Run 'chmod +x enhanced_backup_odoo.sh' after downloading. If the error persists, check that the BACKUP_DIR path is writable by your user: 'ls -ld /path/to/backup/dir'. You may need to run 'sudo chown $USER:$USER /backup/path'.
The backup completes but the file size seems too small. Is it corrupted?

Small backup sizes are usually normal due to compression. To verify integrity, run: 'pg_restore --list backup.dump | head'. You should see a table listing. For filestore archives, use: 'tar -tzf filestore.tar.gz | wc -l' to count files. Compare this to your actual filestore directory.
Can I backup multiple Odoo databases with one script?

This free script handles one database at a time. For multi-database environments, either run the script multiple times with different DB_NAME values, or upgrade to the Master Pack's Multi-Instance Backup Orchestrator which manages multiple databases, coordinates timing, and consolidates logs.
Does this script handle the filestore as well as the database?

Yes, by default this script backs up both the PostgreSQL database and the Odoo filestore directory. You can disable filestore backup by setting BACKUP_FILESTORE=false in the configuration section.
How do I restore from a backup created by this script?

Use pg_restore for the database: 'pg_restore -d your_db backup.dump'. For the filestore: 'tar -xzf filestore.tar.gz -C /path/to/odoo/data/filestore/'. See our Emergency Restore Guide for detailed step-by-step instructions including service stops and permission fixes.

Upgrade to Enterprise-Grade: The Master Pack

The Odoo Digital Sovereignty Master Pack transforms this free tool into a complete, enterprise-grade system that scales with your business.

What You Get

Module 4: Fortress Protection - Complete Backup Ecosystem Multi-target cloud sync (S3, Backblaze B2, Google Drive), automated disaster drill scripts, and one-click restore verification.
Disaster Recovery Playbook Comprehensive manual covering 14 disaster scenarios—restore your production system from scratch in under 30 minutes.
Backup Health Monitoring Dashboard Real-time visibility into backup status, storage capacity, and recovery windows with proactive alerting.

Investment: $699 one-time payment (not subscription)

What you avoid: $15,000-$50,000 in consultant fees + months of trial-and-error

Includes: 5 comprehensive modules with 68+ integrated tools, 2,000+ pages of documentation, and direct email support

View Master Pack Details →

Related Free Resources

Explore other production-ready scripts and tools:

→ Browse all 75+ free scripts

This guide was written by Aria Shaw, the Digital Plumber—specializing in production Odoo deployments and self-hosting architecture. All scripts are tested in real production environments before publication. Questions? Email aria@ariashaw.com