title: How should I terminate a process when pg_cancel_backend doesn't work?
body: <p>Occassionally a query will continue to run even after I 'stop' it in pgAdmin, run <code>pg_cancel_backend</code>, <code>pg_terminate_backend</code> and kill from the command line. The only option I've found is to fully stop and restart the postgres service (generally using <code>pg_ctl -m immediate</code>). I'm currently using <strong>Postgres 9.1</strong>.</p>
  
  <p>Are there other options to fully terminate a running process?</p>