IMPORTING DATA FROM HEROKU TO LOCAL MACHINE

Install the Heroku Backup tool

$ heroku addons:add pgbackups
Start using it

$ heroku pgbackups:capture
Download the remote db on Heroku (to your local machine) using curl

$ curl -o latest.dump `heroku pgbackups:url`
Load it*

$ pg_restore