Today I found myself needing to move data between two heroku apps. If you have the pgbackups addon installed, it turns out this is really easy:

1

heroku pgbackups:restore DATABASE `heroku pgbackups:url --app myapp` --app myapp-staging

Heroku covers the process more in depth in their documentation

Heroku rocks!