Re: transactoin id wraparound problem

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: transactoin id wraparound problem
Дата
Msg-id 20060906121520.GD31856@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на transactoin id wraparound problem  ("Sriram Dandapani" <sdandapani@counterpane.com>)
Список pgsql-admin
On Tue, Sep 05, 2006 at 10:45:40PM -0700, Sriram Dandapani wrote:
> WARNING:  database "xxx" must be vacuumed within 10094646 transactions
>
>
>
> I shutdown, restart pg and issue a vacuumdb -f <database>

-f does _not_ mean "vacuum all databases".  It means "do VACUUM
FULL".  These aren't the same thing.  My bet is what you need is

vacuumdb -a

You've probably missed a database you don't know is there.

A


--
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs

В списке pgsql-admin по дате отправления:

Предыдущее
От: Niklas Johansson
Дата:
Сообщение: Re: How to check if VACUUM operations are working?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: transactoin id wraparound problem