title: pg_terminate_backend - how to enable its execution by a non-superuser?
body: <p>I'm writing a function that kills all current operations running on the server, however, <code>pg_terminate_backend</code> only allows superusers to execute it. I've searched around but have failed to find a concrete solution or lead regarding this.</p>
  
  <p>Is it actually possible granting a certain user permission to execute it without making that user a superuser?</p>
  
  <p>Furthermore, I've managed to find some information about people using security definers. I've never used those and didn't really find a use-case of it with pg_terminate. </p>
  
  <p>Anyone ever had any experience with this or knows whether this is possible?</p>