Zálohování Weblate s PostgreSQL pomocí restic

Poznámka: Související příspěvky:

How To Install Restic REST Server On Synology NAS pro nastavení serveru (můžete také použít jiné backendy)
Naše nastavení Weblate založené na docker-compose: 10-minute Weblate setup using docker-compose & Traefik

Konfigurace zálohovacího skriptu

Nejprve vygenerujte šifrovací heslo pomocí

backup.sh

pwgen 30 > .restic_password

pwgen 30 > .restic_password

Ujistěte se, že jste toto heslo zálohovali samostatně, jinak PŘIJDETE O VŠECHNA DATA!

Nyní vytvořte backup.sh ve stejném adresáři jako docker-compose.yml:

weblate_backup.sh

#!/bin/bash
export NAME=$(basename $(pwd))
export RESTIC_REPOSITORY=rest:http://restic:abc123@10.1.2.3:16383/$NAME
export RESTIC_PASSWORD_FILE=.restic_password

if [ ! -f "${RESTIC_PASSWORD_FILE}" ]; then
   echo "Please create .restic_password with the backup encryption password AND BACKUP THAT PASSWORD SEPARATELY!!!"
   exit 1
fi
echo "Initing repo, please ignore any 'already exists' errors"
if [ ! -f ".restic_inited" ]; then
    # Run the restic init command
    restic init

    if [ $? -eq 0 ]; then # if init successful
        # Create the initialization file
        touch ".restic_inited"
        echo "Restic initialized"
    fi
fi

# Backup
source .env
docker-compose exec -T database pg_dump -U${POSTGRES_USER} ${POSTGRES_DB} | restic --verbose backup --stdin --stdin-filename="${NAME}.sql"
# Backup files
restic --verbose backup backup.sh docker-compose.yml weblate_data --exclude weblate_data/backups --exclude '**/__pycache__'

#!/bin/bash
export NAME=$(basename $(pwd))
export RESTIC_REPOSITORY=rest:http://restic:abc123@10.1.2.3:16383/$NAME
export RESTIC_PASSWORD_FILE=.restic_password

if [ ! -f "${RESTIC_PASSWORD_FILE}" ]; then
   echo "Please create .restic_password with the backup encryption password AND BACKUP THAT PASSWORD SEPARATELY!!!"
   exit 1
fi
echo "Initing repo, please ignore any 'already exists' errors"
if [ ! -f ".restic_inited" ]; then
    # Run the restic init command
    restic init

    if [ $? -eq 0 ]; then # if init successful
        # Create the initialization file
        touch ".restic_inited"
        echo "Restic initialized"
    fi
fi

# Backup
source .env
docker-compose exec -T database pg_dump -U${POSTGRES_USER} ${POSTGRES_DB} | restic --verbose backup --stdin --stdin-filename="${NAME}.sql"
# Backup files
restic --verbose backup backup.sh docker-compose.yml weblate_data --exclude weblate_data/backups --exclude '**/__pycache__'

Automatické spuštění zálohovacího skriptu

Viz How To Create A Systemd Backup Timer & Service In 10 Seconds

TL;DR: V adresáři, kde se nachází backup.sh, spusťte

create_backup_service.sh

wget -qO- https://techoverflow.net/scripts/create-backup-service.sh | sudo bash /dev/stdin

wget -qO- https://techoverflow.net/scripts/create-backup-service.sh | sudo bash /dev/stdin