sujaypillai · June 17, 2015 18:47 · sujaypillai · Jun 17, 2015
diff --git a/KILL pgsql sessions b/KILL pgsql sessions
 postgres=# SELECT                                                                                                         
 postgres-#     pg_terminate_backend(pid) 
 postgres-# FROM 
 postgres-#     pg_stat_activity 
 postgres-# WHERE 
 postgres-#     -- don't kill my own connection!
 postgres-#     pid <> pg_backend_pid()
 postgres-#     -- don't kill the connections to other databases
 postgres-#     AND datname = 'alfresco'
 postgres-# ;
	postgres=# SELECT
	postgres-# pg_terminate_backend(pid)
	postgres-# FROM
	postgres-# pg_stat_activity
	postgres-# WHERE
	postgres-# -- don't kill my own connection!
	postgres-# pid <> pg_backend_pid()
	postgres-# -- don't kill the connections to other databases
	postgres-# AND datname = 'alfresco'
	postgres-# ;