echo "DB is DOWN. Run maintenance now." 5. Start DB sudo systemctl start postgresql 6. Re-enable connections psql -d $DB_NAME -c "ALTER DATABASE $DB_NAME ALLOW_CONNECTIONS true;" 7. Disable maintenance page curl -X POST https://api.myapp.com/maintenance/disable
echo "Starting DBDown sequence..." curl -X POST https://api.myapp.com/maintenance/enable 2. Block writes (PostgreSQL) psql -d $DB_NAME -c "ALTER DATABASE $DB_NAME ALLOW_CONNECTIONS false;" 3. Terminate idle connections psql -d $DB_NAME -c "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='$DB_NAME' AND state='idle';" 4. Stop DB sudo systemctl stop postgresql dbdown
echo "DB is UP and operational." If you meant a specific tool named (e.g., from a GitHub repo or a game modding tool), share the link or context and I’ll tailor the guide exactly. echo "DB is DOWN
echo "DB is DOWN. Run maintenance now." 5. Start DB sudo systemctl start postgresql 6. Re-enable connections psql -d $DB_NAME -c "ALTER DATABASE $DB_NAME ALLOW_CONNECTIONS true;" 7. Disable maintenance page curl -X POST https://api.myapp.com/maintenance/disable
echo "Starting DBDown sequence..." curl -X POST https://api.myapp.com/maintenance/enable 2. Block writes (PostgreSQL) psql -d $DB_NAME -c "ALTER DATABASE $DB_NAME ALLOW_CONNECTIONS false;" 3. Terminate idle connections psql -d $DB_NAME -c "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='$DB_NAME' AND state='idle';" 4. Stop DB sudo systemctl stop postgresql
echo "DB is UP and operational." If you meant a specific tool named (e.g., from a GitHub repo or a game modding tool), share the link or context and I’ll tailor the guide exactly.