Postgres Pro
Downloads
Home   >   mailing lists

Fw: postgrepsql vacuum - Mailing list pgsql-general

From wenjing wu
Subject Fw: postgrepsql vacuum
Date
Msg-id 031001c8cbe9$3efd8640$3c62d38d@D3VCM3D1
Whole thread Raw
Responses Re: Fw: postgrepsql vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
 

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
 
 

pgsql-general by date:

Previous
From: sang hyun Lee
Date:
Subject: how to kill postgreSQL session
Next
From: "Bojan"
Date:
Subject: pl/pgsql function with argument of type DATE