Database Reset Guide¶

# Full reset with volume removal
docker compose down -v
docker compose up -d --build

# This removes:
# - All user accounts
# - All documents and embeddings
# - All chats and missions
# - All configuration

# Check database health and consistency
./maestro-cli.sh reset-db --check

# View detailed statistics
./maestro-cli.sh reset-db --stats

# Create backup before reset
./maestro-cli.sh reset-db --backup

# This will:
# 1. Create timestamped backup
# 2. Reset database
# 3. Reinitialize schema
# 4. Keep backup for recovery

# Reset without confirmation prompts (DANGEROUS!)
./maestro-cli.sh reset-db --force

./maestro-cli.sh reset-db [OPTIONS]

Options:
  --backup  Create timestamped backups before reset
  --force   Skip confirmation prompts (DANGEROUS!)
  --stats   Show database statistics only (don't reset)
  --check   Check data consistency across databases only
  --help    Show help message

# Interactive password reset (will prompt for new password)
docker exec -it maestro-backend python reset_admin_password.py

# Reset with specific username
docker exec -it maestro-backend python reset_admin_password.py --username admin

# Non-interactive reset with password
docker exec -it maestro-backend python reset_admin_password.py --password "newpassword123" --non-interactive

# List all admin users
docker exec -it maestro-backend python reset_admin_password.py --list

reset_admin_password.py [OPTIONS]

Options:
  --username, -u     Username to reset (default: admin)
  --password, -p     New password (will prompt if not provided)
  --non-interactive  Run without prompts
  --list, -l         List all admin users

# Reset admin password to 'admin123' (for development only)
docker exec maestro-backend python reset_admin_password.py --username admin --password admin123 --non-interactive

# Check system-wide consistency status
docker exec maestro-backend python cli_document_consistency.py system-status

# Check consistency for a specific user
docker exec maestro-backend python cli_document_consistency.py check-user <user_id>

# Clean up orphaned documents for a user
docker exec maestro-backend python cli_document_consistency.py cleanup-user <user_id>

# Clean up all users' orphaned documents
docker exec maestro-backend python cli_document_consistency.py cleanup-all

# Force remove volumes
docker volume ls | grep maestro
docker volume rm maestro_postgres_data -f

# Nuclear option - removes everything
docker system prune -a --volumes

# Check logs
docker compose logs postgres

# Common fix: wait longer for initialization
docker compose down
docker compose up -d postgres
sleep 30  # Give more time for database initialization
docker compose up -d