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