Skip to content

Instantly share code, notes, and snippets.

@yorzi
Created January 15, 2013 04:27
Show Gist options
  • Save yorzi/4536058 to your computer and use it in GitHub Desktop.
Save yorzi/4536058 to your computer and use it in GitHub Desktop.
Taps is no longer the recommended tool to use when migrating data between postgres instances. Please give heroku-pg-transfer (https://github.com/ddollar/heroku-pg-transfer) a try instead.

First, find the URL to your db on Heroku:

$ heroku config:get DATABASE_URL
postgres://yada:[email protected]:5432/123

Then transfer from the heroku db to your local db:

$ heroku plugins:install https://github.com/ddollar/heroku-pg-transfer
$ heroku pg:transfer -t postgres://localhost/dbname -f postgres://yada:yada@ec2.../123

Since the heroku-pg-transfer tool utilizes postgres's native pg_dump facility it is a much more predictable and resilient tool.

There is a blog post about this: http://www.ryandaigle.com/a/pgtransfer-is-the-new-taps

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