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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
