aghuddleston · August 29, 2015 14:19
diff --git a/gistfile1.txt b/gistfile1.txt
 Get the Heroku db as detailed here:
 http://devcenter.heroku.com/articles/pgbackups#exporting_via_a_backup

 1. heroku pgbackups:capture
 2. heroku pgbackups:url <backup_num>  #=>backup_url
   -  get backup_num with cmd "heroku pgbackups"
 3. curl -o latest.dump <backup_url>

 Then locally do:
 $ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump

 (your database must exist before can do this)
	Get the Heroku db as detailed here:
	http://devcenter.heroku.com/articles/pgbackups#exporting_via_a_backup

	1. heroku pgbackups:capture
	2. heroku pgbackups:url <backup_num> #=>backup_url
	- get backup_num with cmd "heroku pgbackups"
	3. curl -o latest.dump <backup_url>

	Then locally do:
	$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump

	(your database must exist before can do this)