Re: pg_terminate_backend not working

2019-09-24 Thread bhargav kamineni
> Hi Team , > > We are observing long running process hung in active state on one of > our db from last two days with usename 'xyz', We have tried killing > the respective pid with pg_terminate_backned(pid), it's returning > true but the quires are not actually being terminated. Based on the >

Re: pg_terminate_backend not working

2019-09-24 Thread Jerry Sievers
bhargav kamineni writes: > Hi Team , > > We are observing long running process hung in active state on one of > our db from last two days with usename 'xyz', We have tried killing > the respective pid with pg_terminate_backned(pid), it's returning > true but the quires are not actually being

Re: pg_terminate_backend not working

2019-09-24 Thread bhargav kamineni
Any thoughts on this ? On Tue, 24 Sep 2019 at 16:44, bhargav kamineni wrote: > Hi Team , > > We are observing long running process hung in active state on one of our > db from last two days with usename 'xyz', We have tried killing the > respective pid with pg_terminate_backned(pid), it's

pg_terminate_backend not working

2019-09-24 Thread bhargav kamineni
Hi Team , We are observing long running process hung in active state on one of our db from last two days with usename 'xyz', We have tried killing the respective pid with pg_terminate_backned(pid), it's returning true but the quires are not actually being terminated. Based on the client address