postgresql: template1 is being accessed by other users

1.查询所有的进程:  select * from pg_stat_activity where DATNAME = 'template1';

2.杀掉占用资源的进程:SELECT pg_terminate_backend(126706062);

posted @ 2017-07-03 14:48  zhao379028604  阅读(265)  评论(0编辑  收藏  举报