Backup, Clear, And Restore A Postgresql Database For Rails

Posted by Weston Ganger

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

Date:June 19, 2014

Want me to help develop your next project or application?

Specializing in Ruby, Rails, Crystal, Javascript, Linux, & Databases