postgresql杀进程

概述SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,        pg_stat_get_backend_activity(s.backendid) AS current_query     FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;     杀掉某个进程为:

SELECT pg_stat_get_backend_pID(s.backendID) AS procpID,
pg_stat_get_backend_activity(s.backendID) AS current_query
FROM (SELECT pg_stat_get_backend_IDset() AS backendID) AS s;

杀掉某个进程为: select pg_cancel_backend('2056')

总结

以上是内存溢出为你收集整理的postgresql杀进程全部内容，希望文章能够帮你解决postgresql杀进程所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。