Re: Really odd corruption problem: cannot open pg_aggregate:

On Thu, 24 Jul 2003, Adam Haberlach wrote:

>     So, one of the many machines that I support seems to have developed
> an incredibly odd and specific corruption that I've never seen before.
> 
> Whenever a query requiring an aggregate is attempted, it spits out:
> cannot open pg_aggregate: No such file or directory
> and fails.
> 
> If I do:
> select * from pg_class where relname='pg_aggregate';
> I see that the relation exists.
> 
> If I check the relfilenode in the data directory, that exists, and
> seems to be an object file containing what should be the basic
> aggregate functions.
> 
> version:  PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
> 
> 
>     The system ran for a few weeks before anything odd happened, and
> then suddenly this.  Does anyone have any ideas?  Now that I look at
> the above string, I realize that the system /is/ an Athlon processor.
> Does anyone know if there could be an issue between the i686 and
> athlon optimizations?

test your memory and drive subsystem first.  memtest86.com has a nice 
tester for free, and on linux badblocks can do a decent job (not great, 
just decent) of finding bad blocks.  

Postgresql is good, but it can't make up for bad hardware.