This repository has been archived by the owner on Jan 25, 2020. It is now read-only.

Pulling production DB to local

Jump to bottom

Nicky Semenza edited this page Aug 31, 2015 · 1 revision

Prerequisites:

Install postgresql
Change the connection properties in config/database.yml Something like this:

development:
  adapter: postgresql
  encoding: unicode
  database: boilermake
  pool: 5
  username: boilermake

Install the heroku toolbelt and run these commands:

heroku pg:backups capture --app boilermake
curl -o latest.dump `heroku pg:backups public-url --app boilermake`
pg_restore -O -d boilermake latest.dump