The convention here is to in-line replies, or bottom-post. Top-posting makes the archives more difficult to read.
On Thursday, July 4, 2024, Murthy Nunna <
mnunna@fnal.gov> wrote:
pg_terminate_backend(pid) will not work as it expects only one pid at a time.
Interesting…I wouldn’t expect the function calls to interact that way…maybe try putting the select query into a plpgsql DO command loop and then call pg_terminate_backend once per loop iteration.
So, the question is how to rewrite this psql so it loops through all pids one pid at a time?
I can’t tell if you really mean the psql program or are misusing the term to mean something different…the code you wrote doesn’t seem like it would execute in psql.
David J.
