SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='db_name' AND pid<>pg_backend_pid();
ALTER DATABASE db_name RENAME TO db_name_bak;
PostgreSQL 强制重命名数据库
最新推荐文章于 2024-07-03 09:33:55 发布
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='db_name' AND pid<>pg_backend_pid();
ALTER DATABASE db_name RENAME TO db_name_bak;