Fw: postgrepsql vacuum

 

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