Brock Williams <brock@cotcomsol.com> writes:
> I'm getting this message when I try to access one of the databases in
> my cluster:
> FATAL: cache lookup failed for access method 6881280
Unless you are using a custom index access method you didn't tell us
about, this is pretty strong evidence of data corruption in the pg_class
system catalog (specifically some pg_class.relam entry).
If the corruption extends only as far as those four bytes, it'd be
pretty easy to poke the correct value back in ... but it seems likely
that this is just the tip of the iceberg :-(
Please get a copy of pg_filedump from
http://sources.redhat.com/rhdb/utilities.html
and show us a dump of the pg_class file from that database (I like the
format it produces with -i -f options; note pg_class is file 1259 in all
known PG versions).
regards, tom lane