vacuum in single-user mode

From: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
To: pgsql-sql(at)postgresql(dot)org
Subject: vacuum in single-user mode
Date: 2008-08-08 19:02:45
Message-ID: 489C9855.50700@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

A seldom-used database of mine was not recently vacuumed and I've run
into the error: FATAL: database is not accepting commands to avoid
wraparound data loss in database "stop" HINT: Stop the postmaster and
use a standalone backend to vacuum database "stop". In fact, I get this
error while trying to run "vacuumdb -U postgres -a" (and logged in as
postgres).

I haven't the foggiest idea what this means but googled the error and
found a site that seems to suggest that I need to run the vacuum in
"single-user" mode before running VACUUM FULL, but I cannot find out how
to do that, either.

Can anyone lend some advice, please?

Mark

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christophe 2008-08-08 20:04:53 Re: vacuum in single-user mode
Previous Message felix 2008-08-08 03:54:31 Re: DELETE with JOIN