Thank you for reading this post, don't forget to subscribe!
Получаем pid’ы
|
1 2 3 |
<span class="hljs-keyword">select</span> * <span class="hljs-keyword">from</span> pg_stat_activity; |
подставляем полученный pid
|
1 2 3 4 |
<span class="hljs-keyword">select</span> pg_terminate_backend(pid) <span class="hljs-keyword">from</span> pg_stat_activity <span class="hljs-keyword">where</span> pid = <span class="hljs-string">'PID'</span>; |