I would like to know if there is a specific command for rails db:migrate:reset.

I also needed to reset the staging database. The simple 5 steps I did:

  1. delete the database application (YOUR_APP_NAME-db) via fly dashboard
  2. run fly pg create that recreates an app with the PostgreSQL database
  3. run fly secrets set DATABASE_URL=HERE_THE_URL_TO_DB_FROM_STEP_2
  4. run fly ssh console -C 'app/bin/rails db:create'
  5. run fly ssh console -C 'app/bin/rails db:migrate'

that’s all. good luck.

2 Likes