снести сессии

---------------------  когда нужно снести

select * from pg_stat_activity where datname='......' \gx

select pg_terminate_backend(pid) from pg_stat_activity where datname='.......';

select pid,query  from pg_stat_activity where usename='v.koversunov' ;

select pg_terminate_backend(pid)  from pg_stat_activity where usename='v.koversunov' ;

• pg_cancel_backend(pid): Terminate a query but keep the connection alive
• pg_terminate_backend(pid): Terminate a query and kill the connection