HerokuDbRestore

A (for now) very opinionated gem which has 3 sections:

• pipeline/app setup
• db restore (pull down your heroku database and psql < tmp/latest.db)
• db_restores (push to heroku remotes)

These tasks all assume your heroku application names are of the format "#{Rails.application.class.parent_name.underscore.gsub('_','-')}-#{environment}", where environment is one of staging, production. Setting up an app includes the following free Heroku addons:

*heroku-postgresql:hobby-dev *newrelic:wayne *papertrail:choklad *rediscloud:30 *scheduler:standard *sendgrid:starter

App name configuration flags and more detailed documentation will come in a later version.

Installation

Add this line to your application's Gemfile:

gem 'heroku_db_restore', group: :development # No need to include this on production or staging

And then execute:

$ bundle

Or install it yourself as:

$ gem install heroku_db_restore

Usage

To see an updated list of tasks and descriptions: bundle exec rake heroku_db_restore -T heroku_db_restore

rake db:restore                  # Pull Down a copy of the database from the specified heroku environment
rake db:restore:from_local_dump  # Restore from local dump file (defaults to '/tmp/latest.dump' - specify with DUMP_FILE Environmental Variable)
rake db:restore:local            # Erase local development and test database and restore from the local dump file
rake db:restore:production       # Restore a local copy of Heroku's Production Environment database
rake db:restore:staging          # Restore a local copy of Heroku's Staging Environment database

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/ldstudios/heroku_db_restore.

License

The gem is available as open source under the terms of the MIT License.