Exporting the latest Heroku backup to your local machine

instruction.md

1. Download the latest backup to a local file called latest.dump

curl -o latest.dump `heroku pgbackups:url -r production`

2. Load the dump file into the local database. [username] and [database_name] can be found in the database.yml file.

pg_restore --verbose --clean --no-acl --no-owner -h localhost -U [username] -d [database_name] latest.dump