Skip to content

Instantly share code, notes, and snippets.

@ryanlindsey

ryanlindsey/pgbackup.sh

Created January 3, 2014 19:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ryanlindsey/8244910 to your computer and use it in GitHub Desktop.
Save ryanlindsey/8244910 to your computer and use it in GitHub Desktop.
Download ZIP
Import Heroku Postgres to Localhost
Raw
pgbackup.sh
$ heroku pgbackups:capture
$ curl -o latest.dump `heroku pgbackups:url`
$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U MyUser -d MyDB latest.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment