1
0
mirror of https://github.com/jbranchaud/til synced 2026-01-03 07:08:01 +00:00
Files
til/devops/wipe-a-heroku-postgres-database.md

19 lines
697 B
Markdown

# Wipe A Heroku Postgres Database
If you have some sort of non-production version of an application running on
Heroku, you may encounter a time when you need to wipe your database and
start fresh. For a rails project, it may be tempting to do `heroku run rake
db:drop db:setup`. Heroku doesn't want you to accidentally do anything
stupid, so it prevents you from running `rake db:drop`. Instead, you must
send a more explicit command
```
$ heroku pg:reset DATABASE_URL
```
Heroku will ask you to confirm that you indeed want to wipe out the database
and will then proceed.
For the curious reader, running `heroku config` will list the values of a
number of variables including `DATABASE_URL`.