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