Protecting Your Odoo Data: Backup and Recovery Setup Tutorial

#!/bin/bash

# Configuration
BACKUP_DIR="/backups/odoo"
DB_NAME="odoo_production"
DB_USER="postgres"
TIMESTAMP=$(date +%Y-%m-%d_%H-%M-%S)
BACKUP_FILE="$BACKUP_DIR/odoo_backup_$TIMESTAMP.dump"
FILESTORE_BACKUP="$BACKUP_DIR/filestore_backup_$TIMESTAMP.tar.gz"
LOG_FILE="/var/log/odoo_backup.log"

# Create backup directory
mkdir -p $BACKUP_DIR

# Log function
log() {
  echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1" >> $LOG_FILE
}

log "Starting backup for database: $DB_NAME"

# Backup PostgreSQL database (binary format, faster)
pg_dump -U $DB_USER -Fc -d $DB_NAME > $BACKUP_FILE
if [ $? -eq 0 ]; then
  log "Database backup successful: $BACKUP_FILE"
else
  log "ERROR: Database backup failed!"
  exit 1
fi

# Backup filestore directory
tar -czf $FILESTORE_BACKUP /opt/odoo/filestore 2>/dev/null
if [ $? -eq 0 ]; then
  log "FileStore backup successful: $FILESTORE_BACKUP"
else
  log "ERROR: FileStore backup failed!"
  exit 1
fi

# Delete backups older than 30 days (keep last 30 days)
find $BACKUP_DIR -type f -mtime +30 -delete

# Log completion
log "Backup completed. Current backup files:"
ls -lh $BACKUP_DIR >> $LOG_FILE
log "Backup process finished successfully"

exit 0

sudo chmod +x /usr/local/bin/odoo_backup.sh

# Test it manually
/usr/local/bin/odoo_backup.sh

# Check log to verify success
cat /var/log/odoo_backup.log

crontab -e

# Add this line:
0 2 * * * /usr/local/bin/odoo_backup.sh >> /var/log/odoo_backup_cron.log 2>&1

# Verify it's scheduled:
crontab -l

#!/bin/bash

# AWS configuration
AWS_BUCKET="my-company-odoo-backups"
AWS_REGION="us-east-1"
BACKUP_DIR="/backups/odoo"
LOG_FILE="/var/log/odoo_backup_s3.log"

log() {
  echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1" >> $LOG_FILE
}

log "Starting S3 upload"

# Upload recent backups to S3
aws s3 sync $BACKUP_DIR s3://$AWS_BUCKET/ \
  --region $AWS_REGION \
  --sse AES256 \
  --delete

if [ $? -eq 0 ]; then
  log "S3 upload successful"
else
  log "ERROR: S3 upload failed"
  exit 1
fi

log "S3 sync completed"
exit 0

30 3 * * * /usr/local/bin/odoo_backup_s3.sh >> /var/log/odoo_backup_s3_cron.log 2>&1

sudo systemctl stop odoo

sudo su - postgres

# Create new database
createdb odoo_restored

# Give Odoo user access
psql -d postgres -c "ALTER DATABASE odoo_restored OWNER TO odoo;"

exit

# For binary format (pg_dump -Fc)
pg_restore -U postgres -d odoo_restored /backups/odoo/odoo_backup_2025-12-19_02-00-00.dump

# Or for SQL format
psql -U postgres -d odoo_restored < /backups/odoo/odoo_backup_2025-12-19_02-00-00.sql

# Extract filestore from backup
tar -xzf /backups/odoo/filestore_backup_2025-12-19_02-00-00.tar.gz -C /opt/odoo/

# Edit /etc/odoo/odoo.conf:
[options]
db_name = odoo_restored
db_user = odoo
db_password = [your_password]

# Restart Odoo
sudo systemctl restart odoo

#!/bin/bash

# Check if a backup was created in the last 24 hours
BACKUP_DIR="/backups/odoo"
CUTOFF=$(($(date +%s) - 86400))  # 24 hours ago
RECENT_BACKUPS=$(find $BACKUP_DIR -type f -name "*.dump" -newer /tmp/24hours 2>/dev/null | wc -l)

if [ $RECENT_BACKUPS -eq 0 ]; then
  # No recent backups! Send alert
  echo "ALERT: No backups found in last 24 hours!" | mail -s "Odoo Backup Failed" your-email@company.com
  exit 1
else
  echo "Backup check successful. Found $RECENT_BACKUPS recent backups."
  exit 0
fi

30 8 * * * /usr/local/bin/check_odoo_backup.sh

# Encrypt backup before uploading
gpg --symmetric --cipher-algo AES256 /backups/odoo/odoo_backup_2025-12-19.dump

# Creates: odoo_backup_2025-12-19.dump.gpg

# Delete backups older than 7 years
find $BACKUP_DIR -mtime +2555 -delete  # 2555 days = ~7 years