Thread: How to clear a lock?

How to clear a lock?

From
Matt Taylor
Date:
How do I clear a lock that has been left in a database as a result of doing CTL-C when running VACUUM as a metacommand under psql.

Exact screen contents (after logging in thru psql) are

mfgpro=> vacuum;
ERROR:  can't create lock file -- another vacuum cleaner running?

Any and all advice/suggestions welcome and appreciated.
--
__________________________________________________________
Matt Taylor, Operations Manager
S.Megga International
mtaylor@smegga.com