因有连接未释放,无法删除,修改数据库。清除连接语句:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='数据库名称' AND pid<>pg_backend_pid();
因有连接未释放,无法删除,修改数据库。清除连接语句:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='数据库名称' AND pid<>pg_backend_pid();