Обсуждение: Unlock the vacuum
Dear all, Can anyone tell me how to unlocak a vacuum ? Because last time i run the vacuum and stop while running. When i do a vacuumagain this morning, it says michaely=> vacuum; WARN: Can't create a lock file - another vacuum cleaner running ? Thanks for your attention and any solutions will be highly appreciated ! Cheers, /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ | Michael Yeung | | Alpha Network Shop | | Tel:(02)9413-3886 Fax:(02)9413-3617 | | Mobile:0411-233-597 | | mailto:michaely@alphanet.net.au | \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
On Thu, 30 Apr 1998, Michael Yeung wrote: > Dear all, > > Can anyone tell me how to unlocak a vacuum ? Because last time i run the vacuum and stop while running. When i do a vacuumagain this morning, it says > > michaely=> vacuum; > WARN: Can't create a lock file - another vacuum cleaner running ? Assuming that you are *sure* there are no other vacuum processes running, look for: <PGHOME>/data/base/<database>/pg_vlock And remove that... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org