Skip to content

Instantly share code, notes, and snippets.

@kagemusha

kagemusha/gist:1569836

Created January 6, 2012 09:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kagemusha/1569836 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kagemusha/1569836 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. kagemusha created this gist Jan 6, 2012.
    12 changes: 12 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    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)