Dump Heroku Postgres DB and load locally

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)

what if my local is version 8 and heroku is using version 9?

How about a local update?

Thanks.

Cheers mate.

Worked great!

Thanks.
I couldn't execute heroku pgbackups though, so I had to make the backup and download it via https://postgres.heroku.com/databases

Then, another problem arouse - my app wouldn't access the database (relation does not exist error or no schema has been selected to create in) and I had to run

grant usage on schema public to public;
grant create on schema public to public;

using psql, inside the database.

Update: the command is now heroku pg:backups:capture

And heroku pg:backups

thanks!

Been searching around and trying out different commands for 2 hours. Finally, your gist helped me do it. Thanks a ton.