On Sun, Nov 18, 2012 at 10:25 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 11/16/2012 02:34 PM, Harry wrote: >> I am facing problem i.e. connections after execution completed are residing >> in pg_stat_activity and pg_stat_database. >> but when i am trying to kill them manually using pg_terminate_backend (All >> IDLE connections are getting killed but, others like declare, select etc.) >> are not getting killed getting result false. >> Kindly help to resolve this issue. > > More detail is needed. > > Pg version? > > OS and version? > > Exact command output? > > What the queries that're not terminated are doing? > > Why you're terminating them / what problem you're trying to solve?
And: Are you logged in as superuser when you try to kill them, and if not, are the other sessions from your own user? ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
