Re: Postgres will not start due to corrupt index

From: Robert Sosinski [mailto:rsosinski@ticketevolution.com] 
Sent: Wednesday, October 03, 2012 10:54 AM
To: Merlin Moncure
Cc: pgsql-general@postgresql.org; Spike Grobstein
Subject: Re: Postgres will not start due to corrupt index

Hey Merlin,

Thanks.  Starting postgres with -P was something that I did not try.  Does postgres have any GIN or GIST system indexes
though?

I would love to try it out, but the database has already been restored.  Will definitely keep this in mind for the
futurethough.
 

Thanks again for the help,

-- 
Robert Sosinski


I wonder if there is a column in pg catalog, that indicates the type of the index.  I couldn't find one.
So, I ran the following sql trying to find system indexes of gin or gist type:

select * from pg_indexes where schemaname = 'pg_catalog' and (indexdef like '%USING gist%' OR indexdef like '%USING
gin%');

and it returned zero rows.

Regards,
Igor Neyman