All Fuzzy

Reset Heroku production database

I tried a lot of different ways to wipe out Heroku production database. None of it worked. For example, these two are ones I tried that did not work.

$ heroku pg:reset
!    Usage: pg:reset DATABASE

$ heroku pg:reset SHARED_DATABASE --confirm minforum
Resetting SHARED_DATABASE (DATABASE_URL)... failed
!    Resource not found

The only way that worked for me was this.

$ heroku run rake db:reset

You don’t have to migrate the database after because db:reset does this for you. However, it is a good idea to restart Heroku.

$ heroku restart