Dump from PostgreSQL Using PGAdmin

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.

PostgreSQL Backup Database - pgadmin backup

pgAdmin backup options

pgAdmin backup dump options 1

pgAdmin backup dump options 2

pgAdmin backup messages



Adding Heroku Postgresql to PGAdmin

To add your Heroku DB to PGAdmin, first get your credentials from Heroku.

You’ll need your:

  • host
  • DB name
  • port
  • user name
  • password

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.

  1. make sure you are disconnected from the server,
  2. select the Server, right click -> properties, Advanced tab,
  3. in ‘DB restriction’ type in the name of your database(s) enclosed in single quotes and separated by spaces (i.e. ‘db_name’).

Now you’re server should be able to connect and you should just see your DB in the “Databases” section under your server.