vacuum in single-user mode - Mailing list pgsql-sql

From Mark Fenbers
Subject vacuum in single-user mode
Date
Msg-id 489C9855.50700@noaa.gov
Whole thread Raw
Responses Re: vacuum in single-user mode
List 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


pgsql-sql by date:

Previous
From: felix@crowfix.com
Date:
Subject: Re: DELETE with JOIN
Next
From: Christophe
Date:
Subject: Re: vacuum in single-user mode