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