Dumps the database to db/APP_NAME.dump using rake rake db:dump and to restore rake db:restore

db.rake

# lib/tasks/db.rake
namespace :db do

  desc 'Dumps the database to db/APP_NAME.dump'
  task dump: :environment do
    cmd = nil
    with_config do |app, host, port, db, user, password|
      cmd = "PGPASSWORD='#{password}' pg_dump --host #{host} --username #{user} -p #{port} --verbose --clean --no-owner --no-acl --format=c #{db} > #{Rails.root}/db/#{app}.dump"
    end
    puts cmd
    exec cmd
  end

  desc 'Restores the database dump at db/APP_NAME.dump.'
  task restore: :environment do
    cmd = nil
    with_config do |app, host, port, db, user, password|
      cmd = "PGPASSWORD='#{password}' pg_restore --verbose --host #{host} --username #{user} -p #{port} --clean --no-owner --no-acl --dbname #{db} #{Rails.root}/db/#{app}.dump"
    end
    Rake::Task["db:drop"].invoke
    Rake::Task["db:create"].invoke
    puts cmd
    exec cmd
  end

  private

  def with_config
    yield Rails.application.class.parent_name.underscore,
      ActiveRecord::Base.connection_config[:host],
      ActiveRecord::Base.connection_config[:port],
      ActiveRecord::Base.connection_config[:database],
      ActiveRecord::Base.connection_config[:username],
      ActiveRecord::Base.connection_config[:password]
  end
end