Class: K8sflow::Pg::KillAll

Inherits:
PgBase
  • Object
show all
Defined in:
lib/k8sflow/command/pg/killall.rb

Class Method Summary collapse

Methods inherited from PgBase

database, databases, exec_sql, hash_opt, kv_parse, nine_two?, parse_pg_uri, pid_column, psql_cmd, query_column, ssl?, version

Class Method Details

.call ⇒ Object 



13
14
15
16
17
18
19
20
21
22
 
# File 'lib/k8sflow/command/pg/killall.rb', line 13

def self.call
  sql = %Q(
SELECT pg_terminate_backend(#{pid_column})
FROM pg_stat_activity
WHERE #{pid_column} <> pg_backend_pid()
AND #{query_column} <> '<insufficient privilege>'
    )

  puts exec_sql(sql)
end