Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language - Mailing list pgsql-general

From Warren Vanichuk
Subject Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Date
Msg-id Pine.LNX.4.21.0103071112130.13492-100000@urd.street-light.com
Whole thread Raw
In response to Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > freehost=# vacuum analyze;
> > NOTICE:  Rel pg_language: TID 0/1: OID IS INVALID. TUPGONE 1.
> > ERROR:  Index pg_language_oid_index is not a btree
>
> Yeek.  Something's pretty hosed with pg_language_oid_index.  Try
> reindexing it.  (The procedure to reindex a system index is a bit
> arcane, and I have to admit I've never done it myself, but it's in
> the documentation.)

Thank you, I found 'reindex' and followed the instructions and everything
appears to be fairly happy again. :)

Sincerely, Warren


pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: When is 7.1 going out
Next
From: John Madden
Date:
Subject: Re: How robust is postgresql ?