> 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
