"Silvela, Jaime \(Exchange\)" <JSilvela@xxxxxxxx> 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
