kill all connections in postgres

pg-connections.sql

-- identify all connection in host
select datname,
       pid,
       usename,
       application_name,
       client_addr,
       client_hostname,
       backend_start
  from pg_stat_activity
  
-- kill single connection parse pid
select pg_terminate_backend(pid);

-- kill all connections 
select pg_terminate_backend(pid)
  from pg_stat_activity
  where pid pg_backend_pid();