| From: | Warren Little <warren(dot)little(at)meridiascapital(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | vacuum to cleanup transaction wrap around |
| Date: | 2007-03-23 14:55:35 |
| Message-ID: | DBEC6E33-ABEF-496B-8F46-EDB4E06EFB32@meridiascapital.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
All,
have a cluster that hit the wrap-around issue.
We are trying to run the backend vacuum as describe in the manual to
clear up the problem.
I not sure how I should be interrupting the messages I'm receiving
from the vacuum command.
Here is the approach I take so far (note pg 8.1.4 Linux 64bit)
from command line run postgres dbname
at the backend prompt run vacuum
the console spits out the following repeated many times
2007-03-23 08:51:00 MDTWARNING: database "preR14" must be vacuumed
within 999134 transactions
2007-03-23 08:51:00 MDTHINT: To avoid a database shutdown, execute a
full-database VACUUM in "preR14".
There are a few databases in this cluster ( about 6)
Any suggestions would be greatly appreciated.
Warren Little
Chief Technology Officer
Meridias Capital Inc
ph 866.369.7763
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-23 15:18:03 | Re: vacuum to cleanup transaction wrap around |
| Previous Message | Bjarni Ragnarsson | 2007-03-23 13:20:31 | Re: Encoding problems |