drop database 报错

瀚高PG实验室

于 2018-05-03 14:41:53 发布

阅读量3k

点赞数

分类专栏： PostgreSQL之日常维护文章标签： database 数据库

本文链接：https://blog.csdn.net/pg_hgdb/article/details/80179877

版权

PostgreSQL之日常维护专栏收录该内容

197 篇文章 41 订阅

订阅专栏

作者：瀚高PG实验室（Highgo PG Lab）- 天蝎座

highgo=# drop database test;
错误:  55006: 其他用户正在使用数据库 "test"
DETAIL:  那里有1个其它会话正在使用数据库.

[highgo@localhost ~]$ psql
psql (4.0.0)
Type "help" for help.

highgo=# \l
                                         List of databases
       Name        |    Owner    | Encoding |  Collate   |   Ctype    |      Access privileges
-------------------+-------------+----------+------------+------------+-----------------------------
 highgo            | highgo      | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 test_a			   | test 	     | UTF8     | zh_CN.utf8 | zh_CN.utf8 | test=CTc/test
 test 			   | test        | UTF8     | zh_CN.utf8 | zh_CN.utf8 |
 template0         | highgo      | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/highgo                  +
                   |             |          |            |            | highgo=CTc/highgo
 template1         | highgo      | UTF8     | zh_CN.utf8 | zh_CN.utf8 | =c/highgo                  +
                   |             |          |            |            | highgo=CTc/highgo
(5 rows)

highgo=# drop database test;
错误:  55006: 其他用户正在使用数据库 "test"
DETAIL:  那里有1个其它会话正在使用数据库.
highgo=# select * from pg_stat_activity where datname = 'test';
 datid |      datname      | pid  | usesysid |   usename   | application_name | client_addr  | client_hostname | client_port |         backend_start         | xact_start |          query_st
art          |         state_change          | waiting | state | backend_xid | backend_xmin |
                                                                                                                                                                         query
 26617 | test | 9319 |    16384 | partysimple | NAVICAT          | 172.16.12.10 |                 |       29821 | 2018-05-03 11:47:07.757187+08 |            | 2018-05-03 11:47:
41.441561+08 | 2018-05-03 11:47:41.442914+08 | f       | idle  |             |              | SELECT xxxx
(1 row)

highgo=# SELECT pg_terminate_backend(9319);
 pg_terminate_backend
----------------------
 t
(1 row)

highgo=# select * from pg_stat_activity where datname = 'test';
 datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | waiting | state | ba
ckend_xid | backend_xmin | query
-------+---------+-----+----------+---------+------------------+-------------+-----------------+-------------+---------------+------------+-------------+--------------+---------+-------+---
----------+--------------+-------
(0 rows)

highgo=# drop database test;
DROP DATABASE