Class: PostgresConnectionHelper

Inherits:
Object
  • Object
show all
Defined in:
lib/database/postgres_helper.rb

Class Method Summary collapse

Class Method Details

.drop_all_connections(dbname, user, password) ⇒ Object 



2
3
4
5
6
7
8
9
10
11
 
# File 'lib/database/postgres_helper.rb', line 2

def self.drop_all_connections(dbname, user, password)
  conn = PG.connect(:dbname => 'postgres', user: user, password: password)

  q = 'SELECT pg_terminate_backend(pg_stat_activity.pid) ' +
    'FROM pg_stat_activity ' +
    "WHERE pg_stat_activity.datname = '#{dbname}' " +
    'AND pid <> pg_backend_pid(); '

  conn.exec(q)
end