How to empty a Heroku database

Question

I m working on a Ruby on Rails 3 webapp on Heroku  How do I empty the database

User · Accepted Answer

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  amp  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

User · Answer

The complete answer is  for users with multi-db    heroku pg info - which outputs          HEROKU POSTGRESQL RED  lt -- this is DB   Plan         Basic   Status       available   heroku pg reset HEROKU POSTGRESQL RED --confirm app name  More information found in  https   devcenter heroku com articles heroku-postgresql

User · Answer

In case you prefer to use Heroku Web-site    Go to https   postgres heroku com databases Select the database you want to reset Click on a settings button in the right upper corner Click  Reset Database  as shown below  type in  RESET  and press ok

User · Answer

If you are logged in from the console  this will do the job in the latest heroku toolbelt    heroku pg reset --confirm database-name

User · Answer

Now it s also possible to reset the database through their web interface    Go to dashboard heroku com select your app and then you ll find the database under the add-ons category  click on it and then you can reset the database

User · Answer

The current  ie  2017 way to do this is   heroku pg reset DATABASE   https   devcenter heroku com articles heroku-postgresql pg-reset

User · Answer

This is what worked for me  1 clear db   heroku pg reset --app YOUR APP   After running that you will have to type in your app name again to confirm   2 migrate db to recreate   heroku run rake db migrate  --app YOUR APP   3 add seed data to db   heroku run rake db seed --app YOUR APP

User · Answer

To drop the database     heroku pg reset SHARED DATABASE --confirm NAME OF THE APP   To recreate the database     heroku run rake db migrate   To seed the database     heroku run rake db seed     Final step    heroku restart

User · Answer

I contacted Heroku support  and they confirmed that it is a bug with the latest gem  I am using heroku-2 26 2      Charlie - we are aware of this issue with the  heroku  gem and are   working to fix it       Here s the issue if you care to follow-along -   https   github com heroku heroku issues 356      Downgrading to an earlier version of the  heroku  gem should help  I ve been using v2 25 0 for most of today without issue    Downgrade with the following commands   gem uninstall heroku  gem install heroku --version 2 25 0   If you already have multiple gems installed  you may be presented with    Select gem to uninstall   1  heroku-2 25 0  2  heroku-2 26 2  3  All versions    Just uninstall  2 and rerun the command  Joy

User · Answer

Today the command   heroku pg reset --db SHARED DATABASE URL   not working for shared plans  I m resolve using   heroku pg reset SHARED DATABASE

User · Answer

Login to your DB using heroku pg psql and type the following commands   drop schema public cascade  create schema public

User · Answer

I always do this with the one-liner  heroku pg reset DATABASE

User · Answer

Best solution for you issue will be  heroku pg reset -r heroku  --confirm your heroku app name      --confirm your heroku app name   is not required  but terminal always ask me do that command   After that command you will be have pure db  without structure and stuff  after that you can run   heroku run rake db schema load -r heroku   or  heroku run rake db migrate -r heroku

User · Answer

Assuming you want to reset your PostgreSQL database and set it back up  use   heroku apps   to list your applications on Heroku  Find the name of your current application  application name   Then run  heroku config   grep POSTGRESQL   to get the name of your databases  An example could be  HEROKU POSTGRESQL WHITE URL   Finally  given application name and database url  you should run  heroku pg reset  database url  --confirm  application name  heroku run rake db migrate heroku restart

User · Answer

Now it s diffrent with heroku  Try      heroku pg reset DATABASE --confirm

User · Answer

Check your heroku version  I just updated mine to 2 29 0  as follows   heroku --version    gt  heroku-gem 2 29 0  x86 64-linux  ruby 1 9 3   Now you can run   heroku pg reset DATABASE --confirm YOUR APP NAME   Then create your database and seed it in a single command   heroku run rake db setup   Now restart and try your app   heroku restart heroku open

User · Answer

Now the command is  heroku pg reset DATABASE URL --confirm your app name   this way you can specify which app s db you want to reset  Then you can run  heroku run rake db migrate  heroku run rake db seed    or direct for both above commands  heroku run rake db setup    And now final step to restart your app  heroku restart

User · Answer

Heroku has deprecated the --db option now  so now use   heroku pg reset DATABASE URL --confirm  the name of your app    It s a little confusing because you use the literal text SHARED DATABASE but where I have written  the name of your app  substitute the name of your app   For example  if your app is called my great app then you use   heroku pg reset DATABASE URL --confirm my great app

[ruby-on-rails-3] How to empty a Heroku database

Examples related to ruby-on-rails-3

Examples related to heroku