postgres 删除数据库连接

分类: IT文章 • 2025-02-02 22:46:13

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='你的数据库名称' AND pid<>pg_backend_pid()