Restore database from Heroku to local environment

restore-database.txt

$ wget $(heroku pg:backups public-url -a legacy-next-staging) -O tmp/tti_legacy.dump

Remove all conections to database (for example shut down rails servers or rails console).

# From legacy project:
$ bundle exec rake db:drop db:create
$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U ivanbisevac1 -d tti_development tmp/tti_legacy.dump
$ bundle exec rake db:migrate

# On roundabout project:
$ bin/rake db:schema:dump
$ RAILS_ENV=test bin/rake db:schema:load