Kills active connections to a postgres database

killing_pids_in_pg.sql

-- 9.1
-- Terminate connections to a database
SELECT 
  pg_terminate_backend(procpid) 
FROM 
  pg_stat_activity 
WHERE 
  -- don't kill my own connection!
  procpid <> pg_backend_pid()
  -- don't kill the connections to other databases
AND query_start < (NOW() - '1 month'::INTERVAL) and application_name = ''

-- 9.2
-- Terminate connections to a database
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 query_start < (NOW() - '1 month'::INTERVAL) and application_name = ''

SELECT
datid, datname, pid, usename, application_name, client_addr, backend_start, query_start
FROM
pg_stat_activity
WHERE
pid <> pg_backend_pid()
AND query_start < (NOW() - '1 month'::INTERVAL)
ORDER BY datname, application_name, backend_start

SELECT
datid, datname, pid, usename, application_name, client_addr, backend_start, query_start
FROM
pg_stat_activity
WHERE
pid <> pg_backend_pid()
ORDER BY datname, application_name, backend_start