要在系统库执行postgres里执行(正式库一定要慎重!!!)
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='testdb' AND pid<>pg_backend_pid();
DROP DATABASE testdb
要在系统库执行postgres里执行(正式库一定要慎重!!!)
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='testdb' AND pid<>pg_backend_pid();
DROP DATABASE testdb