tools/scripts/eiru-backup.sh

#!/bin/bash

CONTAINER="database"
DB_USER="odoo"
DATE=$(date +%Y%m%d)
DAYS_TO_KEEP=15
BKP_PATH="/mnt/backup/primary_local_bkp/pg"
SYNC_PATH="/mnt/backup/secondary_local_bkp/pg"
TMP_PATH="."

loop_over_systems()
{
    docker ps -a -f "ancestor=odoo/eiru:1.4" --format "{{.Names}}"
}

# perform database backup if docker exist
perform_backups()
{
    local BKP_TODAY_PATH=$(printf "%s/backup_%s" "$BKP_PATH" "$DATE")

    if [ ! -d "$BKP_TODAY_PATH" ]; then
        mkdir "$BKP_TODAY_PATH"
    fi

    for DB_NAME in $@; do
        local TMP_FILE=$(printf "%s/%s.tar" "$TMP_PATH" "$DB_NAME")

        docker exec $CONTAINER pg_dump -U $DB_USER -d $DB_NAME -F tar -C -b -c -f $TMP_FILE
        docker cp $CONTAINER:$TMP_FILE $BKP_TODAY_PATH
        docker exec $CONTAINER rm $TMP_FILE
    done
}

# delete old backups
delete_old_backups() 
{
    find $1 -maxdepth 1 -type d -name "backup_*" -mtime +$2 -exec rm -rf '{}' ';'
}

# sync two backup paths
sync_local_backups_path() 
{
    rsync -arz $1 $2
}

# sync two backup paths remotely
remote_sync_backups_path()
{
    rsync -arz "ssh -p $1" "$2@$3:$4" $5
}

if [ ! -x "$(command -v docker)" ]; then
    echo "cannot perform backup"
    exit 1
fi

perform_backups $@
delete_old_backups $BKP_PATH $DAYS_TO_KEEP

if [ ! -x "$(command -v rsync)" ]; then
    echo "cannot sync backups path"
    exit 1
fi

sync_local_backups_path "$BKP_PATH/" $SYNC_PATH

exit 0