HEROKU
1 2 |
PGPASSWORD='heroku_db_password' pg_dump --no-acl --no-owner -U heroku_db_user -h heroku_db_host heroku_db_name | bzip2 --> db/database_dump.sql.bz2 scp db/database_dump.sql.bz2 someuser@somehost:/tmp |
EC2(VPS)
1 2 3 4 5 |
cd /home/deployer/apps/project/current RAILS_ENV=production bundle exec rake db:drop db:create scp someuser@somehost:/tmp/database_dump.sql.bz2 /home/deployer/apps/project/ bzip2 -d /home/deployer/apps/project/databse_dump.sql.bz2 PGPASSWORD='vps_db_password' psql -h vps_db_host -U vps_db_user vps_db_name < /home/deployer/apps/project/database_dump.sql |