lin/postgresql_backup_restore.md

Created April 8, 2016 07:40

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/lin/48eb91fe47009f4e7c05e8f3ef09e3ca.js"></script>
Save lin/48eb91fe47009f4e7c05e8f3ef09e3ca to your computer and use it in GitHub Desktop.

Raw

1, backup database using:

pg_dump -U ubuntu app_development -f ~/Downloads/app.sql

2, upload to the server.

scp -i ~/.ssh/app.pem ~/Downloads/app.sql ubuntu@[ip]:/var/www/db

3, drop db and create db

dropdb 'app_production'
createbd 'app_production'

4, restore the db

psql -U ubuntu -d app_production -f app.sql

Select an option