Re: Corrupted index - Mailing list pgsql-general

From Tom Lane
Subject Re: Corrupted index
Date
Msg-id 6961.1119549920@sss.pgh.pa.us
Whole thread Raw
In response to Re: Corrupted index  (Akash Garg <akash.garg@gmail.com>)
List pgsql-general
Akash Garg <akash.garg@gmail.com> writes:
> 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?

Rather than doing the math by hand, let dd do it:

dd bs=8k skip=41661 count=1 </path/to/indexfile | od -x

This assumes your PG was built with the default 8k block size, but
if it wasn't you'd presumably know that ...

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: How to compare the schemas ?
Next
From: Douglas McNaught
Date:
Subject: Re: multi-languages in a table