Tasks for importing and exporting DB dumps.

gistfile1.rb

namespace :db do
  task export: [:environment] do
    conn = ActiveRecord::Base.connection_config
    cmd = "PGPASSWORD=#{conn[:password]} pg_dump -Fc -h localhost -U #{conn[:username]} #{conn[:database]} > /tmp/#{conn[:database]}.sql"
    puts cmd
    system cmd
  end

  task :import => [:environment] do
    conn = ActiveRecord::Base.connection_config

    cmd = "PGPASSWORD=#{conn[:password]} pg_restore -h #{conn[:host]} -U #{conn[:username]} -d #{conn[:database]} #{ENV['DUMP']} &> /dev/null"
    puts cmd
    system cmd
  end
end