Re: Can't get lock for vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't get lock for vacuum
Date
Msg-id 16201.988297751@sss.pgh.pa.us
Whole thread Raw
In response to Can't get lock for vacuum  (Jean-Arthur Silve <jeanarthur@eurovox.fr>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: I am now Linux and PostgreSQL user, have a question
Next
From: Michelle Murrain
Date:
Subject: Re: I am now Linux and PostgreSQL user, have a question