Restore

Index:

sonar

uv run invenio rero es snapshot create backup -n migration-20250924 -w

sonar dev

uv run invenio rero es snapshot repository create backup /invenio/storage/prod/es-backup

# clean indices
uv run invenio rero es snapshot list backup
uv run invenio rero es snapshot restore backup migration-20250924 --wait

Files [sonar-setup-shell]

# run in sonar-setup-shell
rsync -avr --delete --progress /invenio/storage/files_prod/* /invenio/storage/files/new_files/  --exclude=lost+found --exclude=sonar_prod

DB kerosen

export kerosen

ssh root@kerosen
su - postgres
pg_dump --clean sonar > /database/dump/sonar_prod_20251014.sql
exit

#### import sonar dev
psql -U sonar sonar < /invenio/storage/backup/dump/sonar_prod_20251014.sql
exit

Correct problems

uv run /invenio/storage/scripts/correct_sonar.py utils correct-wrong-pids -t doc -v -c