Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group