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? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
