Re: Postgres will not start due to corrupt index

From: Robert Sosinski [mailto:rsosinski(at)ticketevolution(dot)com]
Sent: Wednesday, October 03, 2012 10:54 AM
To: Merlin Moncure
Cc: pgsql-general(at)postgresql(dot)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 future though.

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