VPS 4 Deploy Agent
f9e14c0b23
- pg-dev/: container PostGIS único multi-DB (ref+dev por template) p/ desgrudar dev da produção; scripts refresh/reset + manifesto (secrets fora do git) - bump scoreodonto.com e subdominio.clube67.com (backends dev apontam p/ pgdev via .env) Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
17 lines
863 B
Bash
Executable File
17 lines
863 B
Bash
Executable File
#!/usr/bin/env bash
|
|
# Reset rápido (segundos): recria <projeto>_dev a partir do <projeto>_ref já existente,
|
|
# SEM ir à VPS3. Uso: ./pg-dev-reset.sh <projeto>
|
|
set -euo pipefail
|
|
PROJ="${1:?uso: ./pg-dev-reset.sh <projeto>}"
|
|
cd "$(dirname "$0")"
|
|
set -a; source ./secrets.env; set +a
|
|
export XDG_RUNTIME_DIR=/run/user/1000 DOCKER_HOST=unix:///run/user/1000/docker.sock
|
|
REF="${PROJ}_ref"; DEV="${PROJ}_dev"
|
|
PSQL(){ docker run --rm --network soc -e PGPASSWORD="$PGDEV_PASSWORD" postgres:18 \
|
|
psql -h pgdev -U devadmin -d postgres -v ON_ERROR_STOP=1 "$@"; }
|
|
PSQL -tAc "SELECT 1 FROM pg_database WHERE datname='$REF';" | grep -q 1 \
|
|
|| { echo "ERRO: $REF não existe — rode ./pg-dev-refresh.sh $PROJ primeiro"; exit 1; }
|
|
PSQL -c "DROP DATABASE IF EXISTS $DEV WITH (FORCE);"
|
|
PSQL -c "CREATE DATABASE $DEV TEMPLATE $REF;"
|
|
echo "OK: $DEV resetado a partir de $REF."
|