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

Re: pg_class corrupted ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno THOMAS <bthomas(at)alea(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_class corrupted ?
Date: 2004-06-22 17:44:01
Message-ID: 19889.1087926241@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Bruno THOMAS <bthomas(at)alea(dot)fr> writes:
> Thank you for your answers. I tried (after having shut down postmaster 
> and started standalone backend) to reindex pg_class but it complains :
> NOTICE:  table "pg_class" wasn't reindexed

> So I tried as you told me, to reindex database, but it answsers :
> ERROR:  catalog is missing 3 attributes for relid 1261
> This is the cause of all my troubles I think.

Did you run the standalone backend with the right options?  (From
memory, -O -P, but check the manual.)

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Bryan EncinaDate: 2004-06-22 17:46:15
Subject: Re: phpmyadmin type thing for postgre?
Previous:From: Gaetano MendolaDate: 2004-06-22 17:38:06
Subject: Re: Capacity Planning

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