SearchOps AI

운영

Production hardening

Redis rate limit, migration deploy gate, backup/restore drill을 운영 환경에 연결하기 전 안전한 계획으로 확인합니다.

Restore drill 단계

Migration gate 단계

필수 입력

데이터 출처

API

계획 ID restore_drill_production_20260622. 실제 DB에는 이 화면이 직접 연결하지 않습니다.

단계	상태	설명	명령
Check migration statuspreflight_migration_status	ready	Confirm Prisma migration status before creating or restoring a backup.	corepack pnpm db:migrate:status
Create PostgreSQL backupcreate_backup	ready	Create a custom-format dump without owner or ACL metadata.	pg_dump --format=custom --no-owner --no-acl "$DATABASE_URL" --file searchops-YYYYMMDD-HHMM.dump
Restore into scratch databaserestore_scratch	ready	Restore the dump into a scratch database isolated from production traffic.	pg_restore --clean --if-exists --no-owner --dbname "$RESTORE_DATABASE_URL" searchops-YYYYMMDD-HHMM.dump
Verify restored databaseverify_restore	ready	Run migration status and read-only smoke checks against the restored database.	corepack pnpm db:migrate:status

GitHub Actions의 임시 PostgreSQL service에서 migrate deploy/status를 검증합니다.

준비됨

단계	상태	설명	명령
Generate Prisma clientgenerate_client	ready	Regenerate the Prisma client from the checked-in schema before migration checks.	corepack pnpm --filter @searchops/db db:generate
Check migration statuspreflight_migration_status	ready	Confirm the target database and checked-in migrations are in a deployable state.	corepack pnpm db:migrate:status
Deploy migrationsdeploy_migrations	ready	Apply checked-in migrations through Prisma migrate deploy.	corepack pnpm db:migrate:deploy
Verify migration status after deploypostdeploy_migration_status	ready	Confirm there are no pending, failed, or divergent migrations after deploy.	corepack pnpm db:migrate:status