1. 断开连接(重命名数据库时,不能有任何连接至改数据库)
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='dbname' AND pid<>pg_backend_pid();
2. 重命名
ALTER DATABASE dbname RENAME TO dbname_bak;
1. 断开连接(重命名数据库时,不能有任何连接至改数据库)
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='dbname' AND pid<>pg_backend_pid();
2. 重命名
ALTER DATABASE dbname RENAME TO dbname_bak;