I was having trouble figuring out how to dump the data from PostgreSQL with PGAdmin until I have this on PostgreSQL Tutorial.
Following the directions, I was able to do a dump as .tar file. They also have instructions on how to restore it.
To add your Heroku DB to PGAdmin, first get your credentials from Heroku.
You’ll need your:
Add a new server using these credentials. In addition, you’ll want to change the server settings, or you’ll see about a thousand DB names in your list.
Now you’re server should be able to connect and you should just see your DB in the “Databases” section under your server.