Daily Docker Backup — demo19 / Epris

v19_epris_docker_backup/
├── bin/
│   ├── backup-demo19.sh          # job harian
│   ├── prune-demo19-backups.sh   # retention
│   ├── restore-demo19-db.sh      # restore Postgres saja
│   └── restore-demo19-full.sh    # DB + 4 volume Odoo
├── config/
│   └── backup.env.example        # → copy jadi backup.env (chmod 600)
├── systemd/
│   ├── odoo-demo19-backup.service
│   └── odoo-demo19-backup.timer
├── docs/
│   └── index.html                # dokumentasi ini
└── README.md

sudo mkdir -p /opt/odoo-backup-demo19 /var/backups/odoo-demo19 /var/log
sudo cp -a ~/scripts/v19_epris_docker_backup/. /opt/odoo-backup-demo19/

sudo cp /opt/odoo-backup-demo19/config/backup.env.example \
        /opt/odoo-backup-demo19/config/backup.env
sudo chmod 600 /opt/odoo-backup-demo19/config/backup.env
sudo chmod 700 /opt/odoo-backup-demo19/bin/*.sh

# Sesuaikan nama container & volume di host ini:
docker ps --format '{{.Names}}'
docker volume ls
sudo nano /opt/odoo-backup-demo19/config/backup.env

# Uji manual
sudo /opt/odoo-backup-demo19/bin/backup-demo19.sh
ls -lah /var/backups/odoo-demo19/latest/
sha256sum -c /var/backups/odoo-demo19/latest/SHA256SUMS

# --- Identity ---
BACKUP_NAME=demo19
BACKUP_ROOT=/var/backups/odoo-demo19
KEEP_DAILY=7
MIN_FREE_GB=5

# --- Containers ---
ODOO_CONTAINER=demo19-odoo
DB_CONTAINER=demo19-db

# --- Postgres (kosongkan password agar baca dari container) ---
PGUSER=odoo
PGPASSWORD=
PGDATABASE=demo-odoo19
PGDUMP_FORMAT=custom

# --- Volumes (cocokkan docker volume ls) ---
VOL_DB_DATA=odoo_db_data
VOL_DATA_DIR=odoo_data_dir
VOL_CUSTOMS=odoo_customs
VOL_CONFIG=odoo_config
VOL_ENTERPRISE=odoo_enterprise

STACK_COMPOSE_FILE=
PACK_BUNDLE=0
HELPER_IMAGE=alpine:3.20
STOP_ODOO_DURING_FILESTORE=0
# BACKUP_RAW_DB_VOLUME=0

LATEST=/var/backups/odoo-demo19/latest
ls -lah "$LATEST"
cat "$LATEST/MANIFEST.txt"
( cd "$LATEST" && sha256sum -c SHA256SUMS )

# Setelah restore full:
docker ps --filter name=demo19
# buka UI Odoo → apps/customs → sample attachment (filestore)

SRC=~/scripts/v19_epris_docker_backup
DST=~/scripts/v18_tlt_docker_backup   # ganti nama project
cp -a "$SRC" "$DST"
cd "$DST"

# rename file demo19 → tlt (contoh)
rename 's/demo19/tlt/' bin/* systemd/* 2>/dev/null || \
  for f in bin/*demo19* systemd/*demo19*; do
    mv "$f" "${f//demo19/tlt}"
  done

# edit identitas di env example
sed -i 's/demo19/tlt/g; s/odoo-demo19/odoo-tlt/g' config/backup.env.example
# lalu: cp config/backup.env.example config/backup.env && nano config/backup.env

#!/usr/bin/env bash
# Deskripsi singkat job.
# Usage: my-script.sh [/path/to/backup.env]
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
ROOT_DIR="$(cd "${SCRIPT_DIR}/.." && pwd)"
ENV_FILE="${1:-${ROOT_DIR}/config/backup.env}"

log() { printf '[%s] %s\n' "$(date -Is)" "$*"; }
die() { log "ERROR: $*"; exit 1; }

[[ -f "${ENV_FILE}" ]] || die "Missing env file: ${ENV_FILE}"
# shellcheck disable=SC1090
source "${ENV_FILE}"

: "${BACKUP_ROOT:?}"
: "${DB_CONTAINER:?}"
: "${ODOO_CONTAINER:?}"

command -v docker >/dev/null || die "docker CLI not found"
docker info >/dev/null 2>&1 || die "Cannot talk to Docker daemon"

log "=== start ==="
# … kerja di sini …
log "=== done ==="

SANDBOX=/tmp/epris_backup_sandbox
SCRIPTS=~/scripts/v19_epris_docker_backup
export EPRIS_SANDBOX="$SANDBOX"
export PATH="$SANDBOX/mock-bin:$PATH"

"$SCRIPTS/bin/backup-demo19.sh" "$SANDBOX/backup.env"
"$SCRIPTS/bin/restore-demo19-full.sh" "$SANDBOX/backups/latest" \
  --env-file "$SANDBOX/backup.env" --yes
printf 'YES\n' | "$SCRIPTS/bin/restore-demo19-db.sh" \
  "$SANDBOX/backups/latest/db.dump.gz" --env-file "$SANDBOX/backup.env"

/var/backups/odoo-demo19/
  2026-10-21/
    MANIFEST.txt
    SHA256SUMS
    backup.log
    db.dump.gz                 # atau db.sql.gz
    vol_odoo_data_dir.tar.gz
    vol_odoo_customs.tar.gz
    vol_odoo_config.tar.gz
    vol_odoo_enterprise.tar.gz
    stack.compose.yml          # jika STACK_COMPOSE_FILE di-set
  latest -> 2026-10-21/