Please look at following topic:-
http://www.postgresql.org/docs/9.0/static/functions-admin.html
try using
#SELECT pg_terminate_backend(2738);
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Problem
Hello, everbody
I have the following problem: My vacuum is running since 2013-08-27
18:58:41.527238-03.
billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]--
timestamp | 2013-09-04 11:23:06
billing=# SELECT
pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.qu