Re: some databases have not been vacuumed ...

Поиск
Список
Период
Сортировка
От Gregory S. Williamson
Тема Re: some databases have not been vacuumed ...
Дата
Msg-id 71E37EF6B7DCC1499CEA0316A256832801D4C6EE@loki.wc.globexplorer.net
обсуждение исходный текст
Ответ на some databases have not been vacuumed ...  (FM <dist-list@LEXUM.UMontreal.CA>)
Список pgsql-admin
Did you vacuum the template1 database as well as whatever databases you have created ?

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:    pgsql-admin-owner@postgresql.org on behalf of FM
Sent:    Mon 8/1/2005 12:35 PM
To:    Mailing List Postgres-Admin
Cc:
Subject:    [ADMIN] some databases have not been vacuumed  ...
Hello after a vacuum full analyse I received this  :
WARNING:  some databases have not been vacuumed in 1805294030 transactions
HINT:  Better vacuum them within 342189617 transactions, or you may have
a wraparound failure.

I read that it's because i do not vacuum DB very often.
Now I vacuum every night but the warning remains.
How can I get rid of this ?

Thanks !

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

!DSPAM:42ee7af1176271374616439!





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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: some databases have not been vacuumed ...
Следующее
От: FM
Дата:
Сообщение: Re: some databases have not been vacuumed ...