Kill Postgres connections prior to rake db:drop

gistfile1.rb

task :kill_postgres_connections => :environment do
  db_name = ActiveRecord::Base.configurations[Rails.env.to_s]['database']
  raise "No database name found in #{Rails.env} configuration." if db_name.nil?
  sh = <<EOF
ps xa \
  | grep postgres: \
  | grep #{db_name} \
  | grep -v grep \
  | awk '{print $1}' \
  | xargs kill
EOF
  puts `#{sh}`
end

task "db:drop" => :kill_postgres_connections