DB - postgres restore

db.rb

#!/usr/bin/env ruby
require 'thor'

class MyCLI < Thor
  desc 'download', 'production database'
  def download(remote = 'production')
    puts "Downloading... #{remote}"
    system "#{remote} pg:backups:capture"
    system "curl `#{remote} pg:backups:url` -o #{remote}.dump"
    puts 'Done!'
  end

  desc 'restore', 'load dump in dev database'
  def restore(remote, db)
    system "ps ax | grep postgres: | grep #{db} | cut -c1-8 | xargs kill"
    system "dropdb #{db}; createdb #{db}"
    system "pg_restore --verbose --clean --no-acl --no-owner -j 6 -d #{db} #{remote}"
    system 'touch tmp/restart.txt'
  end

  desc 'dr', 'load dump in dev database'
  def dr
    download('production')
    restore('production', 'honcho')
  end
end

MyCLI.start(ARGV)