Обсуждение: 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