81 lines
1.8 KiB
Bash
81 lines
1.8 KiB
Bash
#!/usr/bin/env bash
|
|
set -Eeuo pipefail
|
|
umask 077
|
|
|
|
# Verwendung:
|
|
# db-postgres-docker.sh CONTAINER DATEINAME
|
|
# db-postgres-docker.sh CONTAINER DATEINAME DB_USER DB_NAME
|
|
|
|
BACKUP_DIR="/media/lars/paperless/db-backup"
|
|
|
|
if [[ $# -ne 2 && $# -ne 4 ]]; then
|
|
echo "FEHLER: Ungueltige Parameteranzahl" >&2
|
|
exit 2
|
|
fi
|
|
|
|
CONTAINER="$1"
|
|
FILENAME="$2"
|
|
|
|
if [[ ! "$FILENAME" =~ ^[a-zA-Z0-9_-]+\.sql$ ]]; then
|
|
echo "FEHLER: Ungueltiger Dateiname" >&2
|
|
exit 2
|
|
fi
|
|
|
|
if [[ ! -d "$BACKUP_DIR" || ! -w "$BACKUP_DIR" ]]; then
|
|
echo "FEHLER: Backup-Verzeichnis nicht verfuegbar" >&2
|
|
exit 1
|
|
fi
|
|
|
|
TARGET="$BACKUP_DIR/$FILENAME"
|
|
TEMP_FILE="$(mktemp "$BACKUP_DIR/.${FILENAME}.XXXXXXXX")"
|
|
|
|
trap 'rm -f -- "$TEMP_FILE"' EXIT
|
|
|
|
echo "Starte PostgreSQL-Backup: $CONTAINER"
|
|
|
|
# Standard: Datenbankparameter aus Container-Umgebung.
|
|
# Ausnahme: explizite Parameter, z.B. Mitai Dev.
|
|
|
|
if [[ $# -eq 2 ]]; then
|
|
CMD=(
|
|
docker exec "$CONTAINER"
|
|
sh -ec '
|
|
: "${POSTGRES_USER:?POSTGRES_USER fehlt}"
|
|
: "${POSTGRES_DB:?POSTGRES_DB fehlt}"
|
|
export PGPASSWORD="${POSTGRES_PASSWORD:-}"
|
|
exec pg_dump -U "$POSTGRES_USER" "$POSTGRES_DB"
|
|
'
|
|
)
|
|
else
|
|
CMD=(
|
|
docker exec "$CONTAINER"
|
|
pg_dump -U "$3" "$4"
|
|
)
|
|
fi
|
|
|
|
if "${CMD[@]}" > "$TEMP_FILE"; then
|
|
echo "Datenbankexport abgeschlossen"
|
|
else
|
|
RC=$?
|
|
echo "FEHLER: pg_dump fehlgeschlagen (Code $RC)" >&2
|
|
exit "$RC"
|
|
fi
|
|
|
|
if [[ ! -s "$TEMP_FILE" ]]; then
|
|
echo "FEHLER: Datenbank-Dump ist leer" >&2
|
|
exit 1
|
|
fi
|
|
|
|
# Auch der Benutzer lars muss die Dateien spaeter
|
|
# mit dem NAS-Kopierskript lesen koennen.
|
|
chgrp lars "$TEMP_FILE"
|
|
chmod 640 "$TEMP_FILE"
|
|
|
|
# Atomarer Austausch auf demselben Dateisystem.
|
|
mv -f -- "$TEMP_FILE" "$TARGET"
|
|
|
|
echo "OK: $TARGET"
|
|
stat -c 'Groesse: %s Bytes' "$TARGET"
|
|
|
|
exit 0
|