KingbaseES（金仓）删除数据库

发表于： 2026年5月19日 2026年5月19日
分类：金仓

删除数据库

DROP DATABASE water;

1	DROP DATABASE water;

如果删除的时候有报错

ERROR:  database "water" is being accessed by other users
DETAIL:  There is 1 other session using the database.

1 2	ERROR: database "water" is being accessed by other users DETAIL: There is 1 other session using the database.

表示现在数据库有链接不能删除数据库

-- 1. 查询是谁在连
SELECT pid, usename, application_name, client_addr, state, query_start, left(query, 80) AS query
FROM sys_stat_activity
WHERE datname = 'water'
  AND pid <> pg_backend_pid();

-- 2. 断开除自己以外的所有 water 连接
SELECT sys_terminate_backend(pid)
FROM sys_stat_activity
WHERE datname = 'water'
AND pid <> pg_backend_pid();

-- 若 sys_terminate_backend 不存在，可试 PostgreSQL 写法：

SELECT pg_terminate_backend(pid)
FROM sys_stat_activity
WHERE datname = 'water'
AND pid <> pg_backend_pid();

-- 1. 查询是谁在连

SELECT pid, usename, application_name, client_addr, state, query_start, left(query, 80) AS query

FROM sys_stat_activity

WHERE datname = 'water'

AND pid <> pg_backend_pid();

-- 2. 断开除自己以外的所有 water 连接

SELECT sys_terminate_backend(pid)

FROM sys_stat_activity

WHERE datname = 'water'

AND pid <> pg_backend_pid();

-- 若 sys_terminate_backend 不存在，可试 PostgreSQL 写法：

SELECT pg_terminate_backend(pid)

FROM sys_stat_activity

WHERE datname = 'water'

AND pid <> pg_backend_pid();

然后再执行你原来的命令，例如：

DROP DATABASE water;

1	DROP DATABASE water;

zhangcunzhi

207