set -euo pipefail

PG_DB="asp"
BACKUP_DIR="/workspace/pg-backups"
BACKUP_FILE="${BACKUP_DIR}/latest.dump"

mkdir -p "$BACKUP_DIR"

if [ "$(id -u)" -eq 0 ]; then
    PGRUN="runuser -u postgres --"
else
    PGRUN="sudo -u postgres"
fi
${PGRUN} pg_dump -Fc "${PG_DB}" -f "${BACKUP_FILE}.tmp"
mv "${BACKUP_FILE}.tmp" "$BACKUP_FILE"

echo "✅ Backup written to ${BACKUP_FILE}"