Restore a Heroku PG Backup From Another App
If your staging and production instances are both hosted on Heroku, you can restore your production Postgres database to your staging instance from the Heroku CLI. No posting the dump on AWS, no backing up to a local dump, etc.
$ heroku pg:backups capture -rproduction
This will print the name of your new backup; let's call it
b234, and the production app name
$ heroku pg:backups restore my-blog::b234 DATABASE_URL -rstaging
The databases are now in sync.Tweet