On 12/31/19 11:29 AM, David G. Johnston wrote:
On Tuesday, December 31, 2019, Ron <ronljohnsonjr@gmail.com> wrote: But how do you issue a ROLLBACK to a different pid?
You cannot. At that point you need to start from scratch.
pg_terminate_backend(pid int)
And let the problematic app deal with losing its database connection however it will.
David J.
That's what I thought (and privately told OP).
--
Angular momentum makes the world go 'round.