Thread

1. Unlock the vacuum

   Michael Yeung <michaely@alphanet.net.au> — 1998-04-30T00:30:28Z

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

2. Re: [HACKERS] Unlock the vacuum

   Marc G. Fournier <scrappy@hub.org> — 1998-04-30T03:40:28Z

   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