Rake task to terminate idle postgresql connections that prevent a database to be dropped

db_terminate_backend.rake

# http://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection
namespace :db do 
  desc "Fix 'database is being accessed by other users'"
  task :terminate => :environment do
    ActiveRecord::Base.connection.execute <<-SQL
      SELECT 
        pg_terminate_backend(pid) 
      FROM 
        pg_stat_activity 
      WHERE 
        -- don't kill my own connection!
        pid <> pg_backend_pid()
        -- don't kill the connections to other databases
        AND datname = '#{ActiveRecord::Base.connection.current_database}';
    SQL
  end
end

Rake::Task["db:drop"].enhance ["db:terminate"]

+1 just found this and came in very handy

Thanks!!

Awesome. Worked like a charm!