Re: [GENERAL] Problems with vacuum

2013-09-24 Thread sachin kotwal
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

[GENERAL] Problems with vacuum

2013-09-04 Thread JotaComm
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