How to empty a Heroku database

by

To drop the database, if you are using SHARED_DATABASE_URL:

$ heroku pg:reset DATABASE_URL

Now to recreate the database with nothing in it:

$ heroku run rake db:migrate

To populate the database with your seed data:

$ heroku run rake db:seed

—OR—

You can combine the last two (migrate & seed) into one action by executing this:

$ heroku run rake db:setup

Edit 2014-04-18: rake db:setup doesn’t work with Rails 4, it fails with a Couldn't create database error.

Edit 2014-10-09: You can use rake db:setup with Rails 4. It does give you a Couldn't create database error (because the database was already created using the heroku pg:reset command). But it also loads your database schema and your seeds after the error message.

You can do this with pretty much any rake command, but there are exceptions. For example, db:reset doesn’t work via heroku run rake. You have to use pg:reset instead.

More information can be found in Heroku’s documentation:

Running Rake Commands

Reset Postgres DB

More Related Contents:

  1. Share database between 2 apps in Heroku
  2. How can I specify a gem to pull from a private github repository?
  3. rails error, couldn’t parse YAML
  4. Undefined method ‘task’ using Rake 0.9.0
  5. Understanding :source option of has_one/has_many through of Rails
  6. Implement “Add to favorites” in Rails 3 & 4
  7. Turn off CSRF token in rails 3
  8. Stubbing authentication in request spec
  9. Rails’ link_to method: GETing when it should DELETE
  10. Rails 3.1: Engine vs. Mountable App
  11. How to fix the uninitialized constant Rake::DSL problem on Heroku?
  12. Disable HTML escaping in erb templates
  13. Separate REST JSON API server and client? [closed]
  14. “Who’s Online” using Devise in Rails
  15. default_url_options and rails 3
  16. rmagick gem install “Can’t find Magick-config”
  17. Rails Engine – Gems dependencies, how to load them into the application?
  18. Rails 3 library not loading until require
  19. Clarification on how to use “thumbs_up” voting gem with Rails 3
  20. using Liquid variables inside of a liquid tag call
  21. Rails 3.1 asset pipeline and manually ordered Javascript requires
  22. HABTM Polymorphic Relationship
  23. Rails 3 render action from another controller
  24. rails 3 activerecord order – what is the proper sql injection work around?
  25. Error “…cannot load such file — mysql2/2.0/mysql2 (LoadError)”. On Windows XP with Ruby 2.0.0
  26. Rails 3 – how do I avoid database altogether?
  27. Setting up a polymorphic has_many :through relationship
  28. ActiveRecord Find All not sorting by ID?
  29. Does accepts_nested_attributes_for work with belongs_to?
  30. Default_url in Paperclip Broke with Asset Pipeline Upgrade

Leave a Comment