hr-lab-sample/scripts/backup.sh

#!/usr/bin/env sh
set -eu
SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)"
ROOT_DIR="$(cd "$SCRIPT_DIR/.." && pwd)"
mkdir -p "$ROOT_DIR/storage/backups"
FILE="/backups/hr_lab_$(date +%Y%m%d_%H%M%S).sql"
docker compose -f "$ROOT_DIR/deploy/docker-compose.yml" exec -T postgres pg_dump -U hr_app -d hr_lab > "$ROOT_DIR/storage/backups/$(basename "$FILE")"
echo "备份已生成: storage/backups/$(basename "$FILE")"