Re: Corrupted index

Akash Garg <akash.garg@gmail.com> writes:
> I'll try running the od command -- I'm just a little confused on where
> I run it.  I tried running od -x 41661 but that doesn't yield any
> results.  I'm assuming I have to run this command on the actual index
> file itself -- how do I do this?

See contrib/oid2name, or read the docs at
http://developer.postgresql.org/docs/postgres/storage.html
to learn how to figure out which file is the index.  (In pre-8.0 PG,
ignore what those docs say about tablespaces, but the rest of the info
goes back a ways.)  The short answer is you need the database's OID
from pg_database, and the index's relfilenode from pg_class.

            regards, tom lane