Skip to content

Instantly share code, notes, and snippets.

@jaischeema

jaischeema/database.rake

Created April 4, 2016 03:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jaischeema/4f4b8049fb26b858ef6040e48f4d2033 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jaischeema/4f4b8049fb26b858ef6040e48f4d2033 to your computer and use it in GitHub Desktop.
Download ZIP
Copy Heroku production database to local database
Raw
database.rake
# http://blog.mccartie.com/2016/03/22/copy-heroku-database-to-local.html?utm_source=rubyweekly&utm_medium=email
namespace :db do
desc "Copy production database to local"
task :copy_production => :environment do
# Download latest dump
system("wget -O tmp/latest.dump `heroku pg:backups public-url -q`")
# get user and database name
config = Rails.configuration.database_configuration["development"]
database = config["database"]
user = config["username"]
# import
system("pg_restore --verbose --clean --no-acl --no-owner -h localhost -d #{database} #{Rails.root}/tmp/latest.dump")
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment