开发者

Destroying a Postgres DB on Heroku

开发者 https://www.devze.com 2023-04-10 14:58 出处:网络
I want to destroy the database but I\'m not sure what the command 开发者_高级运维would be. Does anyone know how to do this?You shouldn\'t use a postgres command to fully delete your database, as you w

I want to destroy the database but I'm not sure what the command 开发者_高级运维would be. Does anyone know how to do this?


You shouldn't use a postgres command to fully delete your database, as you will not have permissions to create a new one. Instead you should use the heroku command to clear out your database:

heroku pg:reset DATABASE_URL


None of the answers above actually describe how to destroy a Heroku database, which was the original question (and what led me here seeking an answer).

From their docs, either of these will work:

  • heroku addons:destroy heroku-postgresql:tier (where tier is the database tier, like hobby-dev)
  • heroku addons:destroy HEROKU_POSTGRESQL_<COLOR> (if you have more than one database of that tier)

Note that because this is a destructive action it will prompt you to confirm the action. If you want to use this in a script you can skip the prompt with something like this:

heroku addons:destroy HEROKU_POSTGRESQL_<COLOR> --confirm <appname>

Hope that's helpful!


To answer Siamii's question above: DATABASE in heroku pg:reset DATABASE is by default postgres


Simply follow the steps below. Run

heroku pg:reset DATABASE

to recreate the database with nothing in it, then run

heroku run rake db:migrate

to initialize the database with the correct schema & data.

Look at the new heroku documentation it helps ;)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号