Re: Can't get lock for vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't get lock for vacuum
Date: 2001-04-26 15:09:11
Message-ID: 16201.988297751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Arthur Silve <jeanarthur(at)eurovox(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2001-04-26 15:10:37 RE: Re: Need for newbie friendly docs (was Newbie strug gling...)
Previous Message Michelle Murrain 2001-04-26 15:07:33 Re: I am now Linux and PostgreSQL user, have a question