postgres 强制断开连接

学习 · 2023-09-15

postgresql 强制断开指定数据库连接

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname=‘数据库名称’ AND pid<>pg_backend_pid();

postgres

Theme Jasmine by Kent Liao