mirror of
https://github.com/fspc/bike-database.git
synced 2025-04-04 10:03:22 -04:00
14 lines
421 B
Markdown
14 lines
421 B
Markdown
To get the dump from a deployed environment:
|
|
|
|
First, create a backup:
|
|
heroku pg:backups:capture --app [app name]
|
|
|
|
Then, download the backup:
|
|
heroku pg:backups:download [backup id] --app [app name]
|
|
|
|
Then, reset the local database:
|
|
rake db:drop db:create db:migrate
|
|
|
|
Then, load the backup into the database:
|
|
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U [username] -d [database name] latest.dump
|