Re: Corruption (Was: Re: Why Not MySQL?)

> As Don asks, what happened with the v7.0 trials you were doing? Corrupted
> indices, I've seen occasionally in older versions, but I can't recall ever
> seeing corrupt system tables ...

I couldn't run the 7.0 beta on our production server. It was forbidden from
"higher up"..

> I don't have a GUI browser right, so searching the archives is kinda tough
> for me :( Can you refresh my memory for me? There has to be something
> logical to this, as to what the cause for the corruption is :(

Ok, the latest thing was "cannot find attribute 15 of relation pg_am" -- I
got that when I tried to do an query.

> >From Don's comment, I take it you are using FreeBSD? Version?
Stability
> of the machine? Never crashes?

FreeBSD 4.0-R

The machine is brand new (we built it because we thought it was a hardware
problem before)..

Ultra 160 SCSI Drives, 512 megs of ECC RAM, PIII 500 processor (soon to be
upgraded).

> Version of PostgreSQL? Compile/configure options? Do you have any core
> files in your data/base/* hierarchy that would be the result of a backend
> crashing?

PG 6.5.3, no core files (this latest time at least, in the past there have
been).

As far as configure options, nothing, just the default configuration...

> I know you are looking at alternatives, but I'm terrible at letting go of
> problems :(

Me too, that's why I've stayed with PG for 6 monthes with these problems..

I wish I had more to tell you now, however I had to restore the data from a
backup.

Thanks!!

-Mitch