Re: [HACKERS] Index corruption

> > Were you the person I told to use pg_upgrade and re-initdb
> your > database? If not, I would recommend that as the fix.
> You may need to > re-enable pg_upgrade by editing the script.
> 
> Nope, but I've tried this now and it fails miserably for me. I
> had to edit the file created by pg_dump quote heavily as I have
> user-defined types and they required some initialisation before
> they could be used in the definition of indexes. Anyway, I
> managed to work around that, and pg_upgrade claimed that everything
> had finished successfully. But, although the datafiles were in
> the right place and the right size all the tables were empty.
> So some system tables were evidently not initialised correctly.
> I tried this both with 6.5.2 and 6.5.3, but no luck either way.

All I can say is someone did this recently for a system index problem
and it worked.

-- Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026