Re: META vacuum - FAIL: ERROR - Mailing list pgsql-novice

From Henshall, Stuart - WCP
Subject Re: META vacuum - FAIL: ERROR
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F748D3@MAIL_EXCHANGE
Whole thread Raw
In response to META vacuum - FAIL: ERROR  (Albert Csaba <maka_cs@yahoo.com>)
List 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 by date:

Previous
From: Wim
Date:
Subject: Unable to access records in table!
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: Unable to access records in table!