Postgres copy Heroku Production DB to local development DB

Use heroku’s “pg:pull”:

You’ll need to clear your local DB:

rake db:drop

Then collect some information from Heroku:

heroku pg:pull DATABASE_URL test_development

This will connect to the heroku DB, and copy it to the local database.

See Heroku’s documentation on pg:pull for more details.