Kill Postgres Connection

select procpid from pg_stat_activity where datname='<dbname>';


from bash: kill <procpid>