## Grab new backup of database

Command: ```heroku pgbackups:capture --remote production```
  
Response: ```>>> HEROKU_POSTGRESQL_COLOR_URL (DATABASE_URL)  ----backup--->  a712```

## Get url of backup download

Command: ```heroku pgbackups:url [db_key] --remote production```  
  
Example: ```heroku pgbackups:url a712 --remote production```

```>>> "https://s3.amazonaws.com/hkpgbackups/app11111118@heroku.com/a712.dump?AWSAccessKeyId=XXXXXXXXXXXXXX&Expires=1367876175&Signature=XXXXXXX%EEEEEEEYWWWWWWW%3D" ```  

## Download backup dump file  

Command: ```curl "http://[url]" > production.dump```  
  
Example: ```curl "https://s3.amazonaws.com/hkpgbackups/app11111118@heroku.com/a712.dump?AWSAccessKeyId=XXXXXXXXXXXXXX&Expires=1367876175&Signature=XXXXXXX%EEEEEEEYWWWWWWW%3D" > production.dump```

## Restore backup dump into local db  

Command: ```pg_restore --verbose --clean --no-acl --no-owner -h localhost -d [db_name] production.dump```