Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 8.2.9 transaction id wraparound failure - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: postgres 8.2.9 transaction id wraparound failure
Date
Msg-id 20090420182602.GE10358@alvh.no-ip.org
Whole thread Raw
In response to Re: postgres 8.2.9 transaction id wraparound failure  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Responses Re: postgres 8.2.9 transaction id wraparound failure  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Free Space after vacuuming  ("Naomi Walker" <nwalker@mhs.mphasis.com>)
List pgsql-admin
Tree view 
Maria L. Wilson wrote:
> I was afraid you'd say that - any quick way to vacuum all 315 databases
> on this machine?

Actually you only need to vacuum the database being complained about --
"postgres" in this case.  You can issue
SELECT datname, age(datfrozenxid) FROM pg_database ORDER BY age(datfrozenxid) DESC
to find whether any other database is going to need vacuuming as well.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: "Maria L. Wilson"
Date:
Subject: Re: postgres 8.2.9 transaction id wraparound failure
Next
From: "Maria L. Wilson"
Date:
Subject: Re: postgres 8.2.9 transaction id wraparound failure