| From: | "wenjing wu" <wuwj(at)umich(dot)edu> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | "wenjing wu" <wuwj(at)umich(dot)edu> |
| Subject: | Fw: postgrepsql vacuum |
| Date: | 2008-06-11 17:33:21 |
| Message-ID: | 031001c8cbe9$3efd8640$3c62d38d@D3VCM3D1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2008-06-11 18:06:01 | Re: encoding confusion |
| Previous Message | Craig Ringer | 2008-06-11 17:31:29 | Re: Unable to dump database using pg_dump |