Backup, Clear, And Restore A Postgresql Database For Rails

Posted by Weston Ganger on June 19, 2014

First Backup your database:

pg_dump dbname > outfile

To clear your database:

dropdb dbname
createdb dbname

To restore database

psql dbname < infile

Then run your migrations

rake db:migrate RAILS_ENV=development

Posted in Linux and Tagged with postgresql rails

Need help on your next project or application?

I specialize in Ruby-on-Rails, AngularJS, Javascript, Bootstrap, and Hybrid Mobile Apps with Cordova & Ionic.