Re: Loss of table structure on 7.3.19

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Loss of table structure on 7.3.19
Дата
Msg-id 10357.1253197836@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Loss of table structure on 7.3.19  (Nigel Metheringham <nigel.metheringham@dev.intechnology.co.uk>)
Список pgsql-admin
Nigel Metheringham <nigel.metheringham@dev.intechnology.co.uk> writes:
> On 17 Sep 2009, at 14:57, Tom Lane wrote:
>> The symptoms indicate pretty strongly that you forgot about vacuuming
>> the system catalogs.  A plain "VACUUM" executed in every database, by
>> a superuser, is sufficient for this.  Trying to be smart by vacuuming
>> only what you think needs vacuumed is not sufficient.

> By "in every database" do you mean we need to vacuum the template*
> databases too?

All the connectable databases, I believe is the rule (although 7.4
was so long it might have done things differently).

            regards, tom lane

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

Предыдущее
От: Nigel Metheringham
Дата:
Сообщение: Re: Loss of table structure on 7.3.19
Следующее
От: Ron Mayer
Дата:
Сообщение: Re: hardware information