MAISA SOLUTIONS, INC. imaginationcoder

We're creators, designers, engineers, educators and problem solvers. Learn more at: www.maisasolutions.com

imaginationcoder / pgherokudump

Last active August 29, 2015 14:15

Dump Heroku Postgres DB locally

	1) Add pgbackups add-on to project
	# heroku addons:add pgbackups
	2) heroku pgbackups:capture
	3) curl -o latest.dump `heroku pgbackups:url`
	4) Then "Translate" it into a postgres db with
	# pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump
	(your database must exist before can do this)