\u5f02\u5e38：<\/p>\n
postgres=# CREATE DATABASE deepflow_agent2;<\/p>\n
ERROR: source database "template1" is being accessed by other users<\/p>\n
DETAIL: There are 2 other sessions using the database<\/p>\n
\u5982\u4f55\u65ad\u8054\u8fd9\u4e24\u4e2asession<\/p>\n<\/p>\n
\u8981\u89e3\u51b3 PostgreSQL \u4e2d\u56e0\u00a0template1\u00a0\u6570\u636e\u5e93\u88ab\u5360\u7528\u5bfc\u81f4\u65e0\u6cd5\u521b\u5efa\u65b0\u6570\u636e\u5e93\u7684\u95ee\u9898，\u8bf7\u6309\u4ee5\u4e0b\u6b65\u9aa4\u64cd\u4f5c：<\/p>\n
SELECT
\n pid,
\n usename,
\n application_name,
\n client_addr,
\n query_start,
\n state
\nFROM
\n pg_stat_activity
\nWHERE
\n datname = 'template1'
\n AND pid <> pg_backend_pid(); — \u6392\u9664\u5f53\u524d\u4f1a\u8bdd <\/p>\n
— \u5bf9\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u6bcf\u4e2a pid \u6267\u884c
\nSELECT pg_terminate_backend(\u76ee\u6807pid); — \u66ff\u6362\u4e3a\u76ee\u6807pid <\/p>\n
SELECT pg_terminate_backend(pid)
\nFROM pg_stat_activity
\nWHERE datname = 'template1'
\n AND pid <> pg_backend_pid(); <\/p>\n
CREATE DATABASE deepflow_agent2 TEMPLATE template0; — \u4f7f\u7528\u7a7a\u767d\u6a21\u677f <\/p>\n
SELECT count(*)
\nFROM pg_stat_activity
\nWHERE datname = 'template1';
\n— \u8fd4\u56de 1 \u8868\u793a\u53ea\u5269\u5f53\u524d\u4f1a\u8bdd <\/p>\n
CREATE DATABASE deepflow_agent2; <\/p>\n
\u6c38\u4e45\u89e3\u51b3\u65b9\u6848：<\/p>\n
ALTER DATABASE template1 ALLOW_CONNECTIONS = OFF; — \u7981\u6b62\u8fde\u63a5\u6a21\u677f\u5e93 <\/li>\n
\u8bbe\u7f6e\u9ed8\u8ba4\u6a21\u677f：<\/p>\n
ALTER DATABASE template1 IS_TEMPLATE = false; — \u53d6\u6d88\u6a21\u677f\u5c5e\u6027 <\/li>\n
\u4f7f\u7528\u4e13\u7528\u6a21\u677f：<\/p>\n
CREATE DATABASE my_template IS_TEMPLATE = true;
\nCREATE DATABASE new_db TEMPLATE my_template; — \u4f7f\u7528\u81ea\u5b9a\u4e49\u6a21\u677f <\/li>\n
pg_terminate_backend()\u00a0\u9700\u8981\u8d85\u7ea7\u7528\u6237\u6743\u9650<\/p>\n<\/li>\n
\u751f\u4ea7\u73af\u5883\u8c28\u614e\u64cd\u4f5c，\u7ec8\u6b62\u4f1a\u8bdd\u53ef\u80fd\u5bfc\u81f4\u7528\u6237\u64cd\u4f5c\u4e2d\u65ad<\/p>\n<\/li>\n
\u4f7f\u7528\u00a0template0\u00a0\u662f\u6700\u5b89\u5168\u7684\u66ff\u4ee3\u65b9\u6848，\u5b83\u662f\u4e0d\u53ef\u4fee\u6539\u7684\u5e72\u51c0\u6a21\u677f<\/p>\n<\/li>\n
\u6267\u884c\u540e\u5982\u679c\u4ecd\u6709\u95ee\u9898，\u68c0\u67e5 PostgreSQL \u65e5\u5fd7：<\/p>\n
tail -n 50 \/var\/log\/postgresql\/postgresql-*.log<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb773\u6b21\uff0c\u70b9\u8d5e18\u6b21\uff0c\u6536\u85cf14\u6b21\u3002\u5f02\u5e38\uff1a\u5982\u4f55\u65ad\u8054\u8fd9\u4e24\u4e2asession\u8981\u89e3\u51b3 PostgreSQL \u4e2d\u56e0template1\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[604,768,100],"topic":[],"class_list":["post-45138","post","type-post","status-publish","format-standard","hentry","category-server","tag-oracle","tag-sql","tag-100"],"yoast_head":"\n