odoo-backup-manager 1.7.0

A comprehensive backup and restore utility for Odoo instances

Odoo Backup Manager

A comprehensive backup and restore utility for Odoo instances with smart GUI/CLI interface, supporting both database and filestore operations with local and remote (SSH) connections.

Features

• 🎯 Smart Interface: Automatically launches GUI when available, falls back to CLI
• 🗄️ Complete Backup & Restore: Handles both PostgreSQL database and Odoo filestore
• 🔒 Secure Storage: Encrypted password storage for connection profiles
• 🌐 Remote Support: Backup/restore from remote servers via SSH
• 💾 Connection Profiles: Save and reuse connection configurations
• 🖥️ Dual Interface: Both GUI and CLI modes available
• 📦 Archive Management: Creates compressed archives with metadata
• 🔄 Flexible Operations: Backup only, restore only, or backup & restore in one operation
• 🛡️ Production Protection: Prevent accidental restores to production databases
• 🧪 Database Neutralization: Safe testing with disabled emails, crons, and payment providers

Installation

Using pip (Recommended)

pip install odoo-backup-manager

From Source

# Clone the repository
git clone https://github.com/jpsteil/odoo-backup-manager.git
cd odoo-backup-manager

# Install the package
pip install -e .

# For development
pip install -r requirements-dev.txt

Prerequisites

• Python 3.8 or higher
• PostgreSQL client tools (pg_dump, pg_restore, psql)
• tar command-line utility
• tkinter (for GUI mode) - usually included with Python

Installing PostgreSQL Client Tools

Ubuntu/Debian

sudo apt-get update
sudo apt-get install postgresql-client

RHEL/CentOS/Fedora

sudo dnf install postgresql

macOS

brew install postgresql

Quick Start

Default Behavior (v1.1.0+)

# Launch the application (GUI if available, otherwise help)
odoo-backup

# Force GUI mode (error if not available)
odoo-backup --gui

# Force CLI mode
odoo-backup --cli

# Show CLI help
odoo-backup --cli --help

GUI Mode

The GUI automatically launches when:

• You run odoo-backup without arguments
• A display is available (not SSH/Docker)
• tkinter is installed

The GUI provides:

• Visual connection management
• Easy backup/restore operations
• Progress tracking
• Connection testing
• Safety features clearly visible

CLI Mode

The CLI is used when:

• You explicitly use --cli flag
• No display is available (SSH, Docker, CI/CD)
• Running in scripts or automation

Connection Profiles (Recommended)

Save Connection Profiles

# Production connection (restore disabled by default for safety)
odoo-backup --cli connections save \
  --name prod \
  --host db.example.com \
  --user odoo \
  --database mydb \
  --filestore /var/lib/odoo

# Development connection (with restore enabled)
odoo-backup --cli connections save \
  --name dev \
  --host localhost \
  --user odoo \
  --database devdb \
  --filestore /var/lib/odoo \
  --allow-restore

Use Connection Profiles

# Backup using connection
odoo-backup --cli backup --connection prod

# Restore using connection (only works if --allow-restore was set)
odoo-backup --cli restore --connection dev --file backup.tar.gz --name test_db

# Restore with neutralization for safe testing
odoo-backup --cli restore --connection dev --file backup.tar.gz --name test_db --neutralize

List Connections

odoo-backup --cli connections list
# Shows 🔒 for production (restore disabled) or ✅ for dev (restore enabled)

Manual Operations (Without Profiles)

Backup Operations

# Backup database and filestore
odoo-backup --cli backup \
  --name mydb \
  --host localhost \
  --user odoo \
  --filestore /var/lib/odoo/filestore

# Backup database only
odoo-backup --cli backup \
  --name mydb \
  --host localhost \
  --user odoo \
  --no-filestore

# Backup with specific output directory
odoo-backup --cli backup \
  --name mydb \
  --host localhost \
  --user odoo \
  --output-dir /backups

Restore Operations

# Restore from backup file
odoo-backup --cli restore \
  --file backup_MYDB_20240101_120000.tar.gz \
  --name newdb \
  --host localhost \
  --user odoo

# Restore with database neutralization (safe for testing)
odoo-backup --cli restore \
  --file backup.tar.gz \
  --name testdb \
  --host localhost \
  --user odoo \
  --neutralize

Database Neutralization

When using the --neutralize flag during restore, the following safety measures are applied:

• ✉️ All outgoing mail servers are disabled
• ⏰ All scheduled actions (crons) are disabled
• 💳 Payment acquirers are disabled
• 📧 Email queue is cleared
• 🏢 Company names are prefixed with [TEST]
• 🔗 Base URL configuration is unfrozen

This ensures your test database won't send emails or execute scheduled tasks.

Automation & Scripting

Cron Job Example

# Add to crontab for daily backups at 2 AM
0 2 * * * /usr/local/bin/odoo-backup --cli backup --connection prod

Bash Script Example

#!/bin/bash
# backup-all-databases.sh

DATABASES=("db1" "db2" "db3")
for DB in "${DATABASES[@]}"; do
    odoo-backup --cli backup --connection prod --name "$DB"
done

Docker Usage

# In your Dockerfile
RUN pip install odoo-backup-manager

# In your script
CMD ["odoo-backup", "--cli", "backup", "--connection", "prod"]

CI/CD Pipeline

# .github/workflows/backup.yml
- name: Backup Odoo Database
  run: |
    odoo-backup --cli backup \
      --name ${{ secrets.DB_NAME }} \
      --host ${{ secrets.DB_HOST }} \
      --user ${{ secrets.DB_USER }} \
      --password ${{ secrets.DB_PASSWORD }}

Configuration

The tool stores its configuration in ~/.config/odoo-backup-manager/:

• config.json: Application settings
• connections.db: Encrypted connection profiles

Default Configuration

{
  "backup_dir": "~/Documents/OdooBackups",
  "default_odoo_version": "17.0",
  "pg_dump_options": ["--no-owner", "--no-acl"],
  "compression_level": 6,
  "max_backup_age_days": 30,
  "auto_cleanup": false,
  "verbose": false
}

Backup File Structure

Backup archives (backup_DBNAME_YYYYMMDD_HHMMSS.tar.gz) contain:

• database.sql: PostgreSQL database dump
• filestore.tar.gz: Compressed filestore data (if included)
• metadata.json: Backup metadata (timestamp, database name, Odoo version)

Security Features

• 🔐 Encrypted Storage: Passwords are encrypted using machine-specific keys
• 🚫 Production Protection: Connections are protected from restore by default
• 🔑 SSH Support: Key-based and password authentication for remote connections
• 🛡️ Safe Defaults: Must explicitly enable restore capability for connections

Troubleshooting

GUI Not Launching

# Check if display is available
echo $DISPLAY

# Install tkinter if missing
sudo apt-get install python3-tk

# Force CLI mode as fallback
odoo-backup --cli [command]

Permission Denied

• Ensure read access to filestore directory
• Ensure write access to backup directory
• Check PostgreSQL user permissions

Connection Issues

# Test connection manually
psql -h hostname -U username -d database -c "SELECT version();"

# Check SSH access for remote connections
ssh user@host "echo 'SSH connection successful'"

Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Run tests: pytest
5. Submit a pull request

License

MIT License - see LICENSE file for details

Support

• Issues: GitHub Issues
• Discussions: GitHub Discussions
• PyPI: odoo-backup-manager

Credits

Developed for the Odoo community to simplify backup and restore operations while maintaining safety and ease of use.