# Docker Compose
docker logs fluidify-regen 2>&1 | grep -i "migrat\|error\|fail"

# Kubernetes
kubectl logs -n fluidify deploy/fluidify-regen | grep -i "migrat\|error\|fail"
# Or check the migration Job (if using Helm):
kubectl logs -n fluidify job/fluidify-regen-migrate

# Docker Compose
docker exec fluidify-regen-db psql -U regen -c \
  "SELECT version, dirty FROM schema_migrations ORDER BY version DESC LIMIT 5;"

# Kubernetes
kubectl exec -n fluidify deploy/postgres -- psql -U regen -c \
  "SELECT version, dirty FROM schema_migrations ORDER BY version DESC LIMIT 5;"

# Docker Compose
docker exec fluidify-regen-db pg_dump -U regen regen > regen-backup-$(date +%Y%m%d-%H%M).sql

# Kubernetes
kubectl exec -n fluidify deploy/postgres -- pg_dump -U regen regen > regen-backup-$(date +%Y%m%d-%H%M).sql

ls backend/migrations/ | grep <version>

# Run the app with the force flag (resets dirty state to the version below the failed one)
docker run --rm --env-file .env ghcr.io/fluidifyai/regen:latest /app/regen migrate force <version-1>

-- Check if the column exists
SELECT column_name FROM information_schema.columns
WHERE table_name='incidents' AND column_name='new_column';

-- If it does and shouldn't yet, drop it
ALTER TABLE incidents DROP COLUMN IF EXISTS new_column;

GRANT ALL PRIVILEGES ON SCHEMA public TO regen;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO regen;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO regen;