Re: Cursor fetch Problem.

On Wednesday, December 26, 2012 5:12 PM Harry wrote:
> Hi All,
>
> I am getting a problem i.e. in database while checking pg_stat_activity
> faced issue statement <Fetch all in unnamed portal> is residing as
> process
> for couple of days also,

How have you concluded, it stays for couple of days?
pg_stat_activity will show last statement executed in backend. What is the
value of 'state' for that backend.
It's better if you can send the output of pg_stat_activity for that backend.

> not able to kill them through pg_terminate_backend  function.
Can you try once pg_cancel_backend(pid) and then pg_terminate_backend.

With Regards,
Amit Kapila.