|
Hi,
Our site run into a pnfs server failure, because of
the postgresql transaction id wraparound problem,
Now , I am trying to vacuum the database companion
in the standalone model:
root@head02
/var/lib/pgsql/data/pg_log# su - postgres
-bash-3.00$ postgres -D /var/lib/pgsql/data WARNING: database "companion" must be vacuumed within 4294599306 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "companion". WARNING: database "companion" must be vacuumed within 4294599306 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "companion". PostgreSQL stand-alone backend 8.1.4
backend> vacuum full WARNING: database "companion" must be vacuumed within 4294599250 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "companion". WARNING: database "companion" must be vacuumed within 4294599249 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "companion". and
it seems the vacuum failed?
any ideas about it?
thanks
wenjing
|
