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@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
