Re: postgres 8.2.9 transaction id wraparound failure

On Mon, 2009-04-20 at 13:49 -0400, Maria L. Wilson wrote:
> running on a linux box
>
> i've inherited this test machine getting the following errors in the
> logs....
>
> scoogan 198.119.134.228 2009-04-20 11:42:48.762 EDT 0 [9181]
> [scoogan_ange_1.2] FATAL: database is not accepting commands to avoid
> wraparound data loss in database "postgres"
> scoogan 198.119.134.228 2009-04-20 11:42:48.762 EDT 0 [9181]
> [scoogan_ange_1.2] HINT: Stop the postmaster and use a standalone
> backend to vacuum database "postgres".
>
> I stopped the server and went into single user mode as the docs
> suggested....
> postgres --single -D /data/pg_devices
>
>
> then i am issuing vacuum full analyze; it returns.....
>
> 2009-04-20 11:37:47.377 EDT [8513] [] WARNING: database "postgres"
> must be vacuumed within 982038 transactions
> 2009-04-20 11:37:47.377 EDT [8513] [] HINT: To avoid a database
> shutdown, execute a full-database VACUUM in "postgres".
>
> trying to restart the server - I still am getting the same initial
> errors....

You have to vacuum each database.

Joshua D. Drake

>
> Am i missing something??
>
> thanks!! Maria Wilson
>
>
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997