Odoo Database Management — Complete Guide to the Database Manager (Odoo 16–19)

; odoo.conf — master password configuration
[options]
admin_passwd = your_strong_master_password_here

; For production: set a long random value (32+ characters)
; and disable the manager entirely (see Security section).
; Never use the default 'admin' value in any environment.

Step 1 — Open the database manager
  Navigate to: https://your-odoo-domain.com/web/database/manager

Step 2 — Click "Backup" next to the database name

Step 3 — Enter the master password

Step 4 — Choose backup format
  - zip (recommended) — includes filestore
  - dump — database only

Step 5 — Click "Backup" to download the file
  File is saved to your browser's download folder.
  Filename format: <db_name>_<YYYY-MM-DD>_<HH-MM-SS>.<format>

Step 6 — Store the backup in a safe off-server location
  At minimum: a different server or cloud storage bucket.
  Never rely solely on a backup file on the same server as the database.

; odoo.conf — production security hardening

[options]
; 1. Disable the database selector on the login screen
;    (hides database list from the login page)
list_db = False

; 2. Set a strong master password (32+ random characters).
;    Even with list_db = False, admin_passwd protects the
;    manager if it's somehow reached.
admin_passwd = <strong-random-32-char-password>

; 3. Lock to a single database name
;    (Odoo will only serve this database; manager is inaccessible)
db_name = your_production_db
db_filter = ^your_production_db$

#!/bin/bash
# Odoo production backup script — run as odoo system user
# Replace DB_NAME and BACKUP_DIR with your values.

DB_NAME="your_production_db"
BACKUP_DIR="/var/backups/odoo"
DATE=$(date +%Y-%m-%d_%H-%M-%S)
FILESTORE="/home/odoo/.local/share/Odoo/filestore/$DB_NAME"

mkdir -p "$BACKUP_DIR"

# 1. Dump the PostgreSQL database
pg_dump -U odoo -Fc "$DB_NAME" > "$BACKUP_DIR/${DB_NAME}_${DATE}.dump"

# 2. Archive the filestore alongside it
tar -czf "$BACKUP_DIR/${DB_NAME}_filestore_${DATE}.tar.gz" -C "$FILESTORE" .

echo "Backup complete: $BACKUP_DIR"

# 3. (Optional) Remove backups older than 7 days
find "$BACKUP_DIR" -name "*.dump" -mtime +7 -delete
find "$BACKUP_DIR" -name "*.tar.gz" -mtime +7 -delete