Re: Corrupted index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Akash Garg <akash(dot)garg(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Corrupted index
Date: 2005-06-23 18:05:20
Message-ID: 6961.1119549920@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Akash Garg <akash(dot)garg(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-06-23 18:16:01 Re: multi-languages in a table
Previous Message Jeff Amiel 2005-06-23 17:58:46 Re: How to compare the schemas ?