Skip to content

Instantly share code, notes, and snippets.

@cjsim89

cjsim89/heroku_pg_db_reset.md

Forked from zulhfreelancer/heroku_pg_db_reset.md
Created February 16, 2023 17:56
Show Gist options
  • Save cjsim89/8a72f9e7959596aabceef7b1e41190d4 to your computer and use it in GitHub Desktop.
Save cjsim89/8a72f9e7959596aabceef7b1e41190d4 to your computer and use it in GitHub Desktop.
Download ZIP
How to reset PG Database on Heroku (for Rails app)?
Raw
heroku_pg_db_reset.md

It's important to note that running this reset will drop any existing data you have in the application

How to reset PG Database on Heroku?

  • Step 1: heroku restart
  • Step 2: heroku pg:reset DATABASE (no need to change the DATABASE)
  • Step 3: heroku run rake db:migrate
  • Step 4: heroku run rake db:seed (if you have seed)

One liner

heroku restart; heroku pg:reset DATABASE --confirm APP-NAME; heroku run rake db:migrate

Note 1

Heroku doesn't allow users from using rake db:reset, rake db:drop and rake db:create command. They only allow heroku pg:reset and rake db:migrate commands.

More info: https://devcenter.heroku.com/articles/rake

Note 2

If you have more than 1 remote, append --remote [your_remote_name] like this:

heroku run rake db:migrate --remote dev (dev is example remote here)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment