Re: Corrupted index

I used oid2name to find the index files:
168807081
168807081.1
168807081.2
168807081.3
168807081.4

Now how do I run the od command to find the block in question?

Thanks,
Akash

On 6/23/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Akash Garg <akash(dot)garg(at)gmail(dot)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
>