Skip to content

Instantly share code, notes, and snippets.

@sfkaos
Forked from kagemusha/gist:1569836
Created July 19, 2013 01:09
Show Gist options
  • Save sfkaos/6034355 to your computer and use it in GitHub Desktop.
Save sfkaos/6034355 to your computer and use it in GitHub Desktop.
Get the Heroku db as detailed here:
http://devcenter.heroku.com/articles/pgbackups#exporting_via_a_backup
1. heroku pgbackups:capture
2. heroku pgbackups:url <backup_num> #=>backup_url
- get backup_num with cmd "heroku pgbackups"
3. curl -o latest.dump <backup_url>
Then locally do:
$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump
(your database must exist before can do this)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment