Re: META vacuum - FAIL: ERROR

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Albert Csaba' <maka_cs(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: META vacuum - FAIL: ERROR
Date: 2002-06-06 09:14:23
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748D3@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)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

Browse pgsql-novice by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-06-06 09:22:30 Re: Unable to access records in table!
Previous Message Wim 2002-06-06 08:55:12 Unable to access records in table!