Re: Can't get lock for vacuum

Jean-Arthur Silve <jeanarthur@eurovox.fr> writes:
> Now It works fine, but I can't do VACUMM, the error message is something
> like "Can't get lock. Is another Vacuum running ?"

> What can I do to reactivate the vacuum ?

There's a file named something pretty obvious (pg_vlock, IIRC) in the
$PGDATA/base/yourdb/ directory.  Remove it.

Also, consider updating to a more recent version of Postgres ;-)

            regards, tom lane