#!/usr/bin/env sh
set -eu
STAMP=$(date +%Y%m%d-%H%M%S)
mkdir -p backups
docker compose exec -T db pg_dump -U "${POSTGRES_USER:-alberto_smith}" "${POSTGRES_DB:-alberto_smith}" | gzip > "backups/alberto-smith-${STAMP}.sql.gz"
find backups -type f -name '*.sql.gz' -mtime +30 -delete
printf 'Respaldo creado: backups/alberto-smith-%s.sql.gz\n' "$STAMP"