pg_cancel_backend()和pg_terminate_backend()

先看下两个函数的官方解释：

 

 

pg_cancel_backend() 取消后台操作，回滚未提交事物

pg_terminate_backend() 中断session，回滚未提交事物

这里和oracle类似kill session的操作是 pg_terminate_backend()

 

pg_cancel_backend()    举例：

session A:

postgres=# create table tb1 (a int);
CREATE TABLE
postgres=# begin;

postgres=# insert into tb1 select generate_series(1,100000000);

session B：

postgres=# select * from pg_stat_activity;
datid | datname | procpid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start
| query_start | waiting | current_query
-------+----------+---------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+--------------------
-----------+-------------------------------+---------+------------------------------------------------------
12699 | postgres | 10305 | 10 | postgres | psql | | | -1