#!/bin/sh

set -e

if [ $# != 1 ]; then
  echo "Usage: $(basename $0) db-name" >&2
  exit 1
fi

dbname="$1"
psql "$dbname" -c '
  SELECT pg_terminate_backend(pg_stat_activity.pid)
  FROM pg_stat_activity
  WHERE datname = '"'$dbname'"' AND pid != pg_backend_pid();
'