"Silvela, Jaime \(Exchange\)" <JSilvela@Bear.com> writes:
>> If the index entries for the system catalogs themselves are hosed,
>> you may have to start the session with PGOPTIONS="-P" (to disable
>> trusting system indexes) in order to do REINDEX successfully.
> Excuse my ignorance, how do I do that. Linux env setting? Is it a
> command line option for Postmaster?
Originally it was only a postmaster command line option, but since about
7.4 you can set it in psql's environment, and that's what I'd recommend
for a one-shot repair effort.
regards, tom lane