Database maintenance on Heroku

Owned by Eddie Rubeiz
Last updated: Jan 20, 2022
1 min read

When you get an email from Heroku that reads…

Your database xxx standard-0 (xxx on scihist-digicoll-production) must undergo maintenance

…. here’s how to do the maintenance at a time of your choosing:

  1. Schedule 10 minutes of downtime

  2. Turn OFF the switch next to DYNO MANAGER at https://manager.hirefire.io/managers/2533bb0e-4eda-4f45-b8ef-3235c1e302df to prevent it from turning workers back on.

  3. heroku ps:scale worker=0 --app scihist-digicoll-production
    heroku maintenance:on --app scihist-digicoll-production
    heroku pg:maintenance:run --force --app scihist-digicoll-production
    heroku pg:wait --app scihist-digicoll-production
    heroku ps:scale worker=2 --app scihist-digicoll-production
    heroku maintenance:off --app scihist-digicoll-production

  4. Turn the Hirefire manager switch back ON.