Disconnect all connection on target database for postgresql.

diconnectdb

#!/usr/bin/env bash
if [ -z "$1" ]; then
        echo "usage> $0 database"
        exit 1
fi

cat <<-EOF | psql -d $1
        SELECT pg_terminate_backend(pg_stat_activity.pid)
        FROM pg_stat_activity
        WHERE pg_stat_activity.datname = '$1'
        AND pid <> pg_backend_pid();
EOF