Re: META vacuum - FAIL: ERROR

Поиск
Список
Период
Сортировка
От Henshall, Stuart - WCP
Тема Re: META vacuum - FAIL: ERROR
Дата
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F748D3@MAIL_EXCHANGE
обсуждение исходный текст
Ответ на META vacuum - FAIL: ERROR  (Albert Csaba <maka_cs@yahoo.com>)
Список pgsql-novice


> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
>
> Hi!
>
> I have a RaQ3 Cobalt server, which uses PostgreSQL.
> Lately I'm getting this error:
>
> NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF
> INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER
> OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP' (561)
> META vacuum - FAIL: ERROR:  cannot find attribute 1 of
> relation quota
>
> What can I do? Can I change manually somehow the
> database?
>
> Any help is welcome,
> Thank you in advance
>
> Csaba Albert

Try reindex from a stand alone postgres (just postgres rather than postmaster).
This should reindex the system tables.
hth,
- Stuart

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

Предыдущее
От: Wim
Дата:
Сообщение: Unable to access records in table!
Следующее
От: "Henshall, Stuart - WCP"
Дата:
Сообщение: Re: Unable to access records in table!