# HG changeset patch
# User smith@nwoca.org
# Date 1429026105 -3600
# Node ID 4f8780714e4def820cd51265865c591ec2f172b2
# Parent  5b142b2b730f26738c65e769e2c3268ce262d91b
disconnect sessions prior to dropping database

diff -r 5b142b2b730f -r 4f8780714e4d init20.gradle
--- a/init20.gradle	Mon Apr 13 16:50:17 2015 +0100
+++ b/init20.gradle	Tue Apr 14 16:41:45 2015 +0100
@@ -291,6 +291,8 @@
                                 gradle.environmentDatabase.jdbc.password,
                                 driverName)
                         if (dropIt) {
+							logger.info "disconnecting sessions from $databaseName"
+							sql.execute "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '$databaseName';"
                             logger.info "dropping $databaseName (if exists) from $adminUrl"
                             sql.execute 'DROP DATABASE IF EXISTS "' + databaseName + '";'
                         }