I also needed to reset the staging database. The simple 5 steps I did:
- delete the database application (YOUR_APP_NAME-db) via fly dashboard
- run
fly pg create
that recreates an app with the PostgreSQL database - run
fly secrets set DATABASE_URL=HERE_THE_URL_TO_DB_FROM_STEP_2
- run
fly ssh console -C 'app/bin/rails db:create'
- run
fly ssh console -C 'app/bin/rails db:migrate'
that’s all. good luck.