Grab new backup Command: heroku pg:backups capture -a [app_name] Download Command: curl -o latest.dump `heroku pg:backups public-url -a [app_name]` Restore backup dump into local db Command: pg_restore --verbose --clean --no-acl --no-owner -h localhost -d [db_name] latest.dump
This was very helpful. Thanks for writing it. +1