Skip to content

Instantly share code, notes, and snippets.

@mvaragnat
mvaragnat / gist:b9d0c8c74ca217743e0308e05050c84e
Created March 19, 2019 08:23 — forked from wrburgess/gist:5528649
Backup Heroku Postgres database and restore to local database

Grab new backup of database

Command: heroku pgbackups:capture --remote production

Response: >>> HEROKU_POSTGRESQL_COLOR_URL (DATABASE_URL) ----backup---> a712

Get url of backup download

Command: heroku pgbackups:url [db_key] --remote production