3e9b9f110a
Update `apply_migrations.sh`, `cleanup_database.sh`, and `debug_system.sh` to robustly load environment variables from the `.env` file, ensuring correct `DATABASE_URL` availability and improving script execution reliability. Replit-Commit-Author: Agent Replit-Commit-Session-Id: 7a657272-55ba-4a79-9a2e-f1ed9bc7a528 Replit-Commit-Checkpoint-Type: full_checkpoint Replit-Commit-Event-Id: b9098694-dc08-42d0-9fe9-48515e4e82a0 Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/449cf7c4-c97a-45ae-8234-e5c5b8d6a84f/7a657272-55ba-4a79-9a2e-f1ed9bc7a528/4LjHWWz
49 lines
1.4 KiB
Bash
Executable File
49 lines
1.4 KiB
Bash
Executable File
#!/bin/bash
|
|
# =============================================================================
|
|
# IDS - Pulizia Database Automatica
|
|
# =============================================================================
|
|
# Esegui giornalmente via cron per mantenere database pulito
|
|
# Esempio cron: 0 3 * * * /opt/ids/deployment/cleanup_database.sh
|
|
# =============================================================================
|
|
|
|
set -e
|
|
|
|
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
|
|
IDS_DIR="/opt/ids"
|
|
|
|
# Carica variabili ambiente ed esportale
|
|
if [ -f "$IDS_DIR/.env" ]; then
|
|
set -a
|
|
source "$IDS_DIR/.env"
|
|
set +a
|
|
fi
|
|
|
|
# Verifica DATABASE_URL
|
|
if [ -z "$DATABASE_URL" ]; then
|
|
echo "[ERROR] DATABASE_URL non impostato"
|
|
exit 1
|
|
fi
|
|
|
|
echo "=========================================="
|
|
echo "IDS - Pulizia Database $(date)"
|
|
echo "=========================================="
|
|
|
|
# Dimensione database PRIMA della pulizia
|
|
echo ""
|
|
echo "📊 Dimensione database PRIMA:"
|
|
psql "$DATABASE_URL" -c "SELECT pg_size_pretty(pg_database_size(current_database()));"
|
|
|
|
# Esegui pulizia
|
|
echo ""
|
|
echo "🧹 Eliminazione log vecchi (>7 giorni)..."
|
|
psql "$DATABASE_URL" -f "$IDS_DIR/database-schema/cleanup_old_logs.sql"
|
|
|
|
# Dimensione database DOPO la pulizia
|
|
echo ""
|
|
echo "📊 Dimensione database DOPO:"
|
|
psql "$DATABASE_URL" -c "SELECT pg_size_pretty(pg_database_size(current_database()));"
|
|
|
|
echo ""
|
|
echo "✅ Pulizia completata - $(date)"
|
|
echo "=========================================="
|