Re: FATAL: cache lookup failed for access method 6881280

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tried to post directy to the list but I got a bounce back. Must be too
big...

Here it is posted to my web site:
http://www.cotcomsol.com/~brock/postgresql_debug.txt

Thanks for the help,
Brock

Tom Lane wrote:
> Brock Williams <brock(at)cotcomsol(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)

iD8DBQFC8EPYgMCVEEcrWuIRAhCcAJ9RZEMrKFpbRfjHOVW1Vfj6eys+VgCfaKhA
2EV6MSgumAvDv+Lv0k2WrdI=
=IZnE
-----END PGP SIGNATURE-----