Horton

Re: [HACKERS] Unlock the vacuum

Marc G. Fournier <scrappy@hub.org>

View thread View on postgr.es
From: The Hermit Hacker <scrappy@hub.org>
To: Michael Yeung <michaely@alphanet.net.au>
Cc: "'Postgres'" <pgsql-hackers@postgreSQL.org>
Date: 1998-04-30T03:40:28Z
Lists: 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 vacuum again 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