Re: [HACKERS] Unlock the vacuum - Mailing list pgsql-hackers

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