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 ?

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		|
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/


Thu, 30 Apr 1998 10:30:28 +1000
Michael Yeung <michaely@alphanet.net.au>
Unlock the vacuum
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 


Thu, 30 Apr 1998 00:40:28 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] Unlock the vacuum