Message-ID: <4C940889.3000505@iii.com>
Date: Fri, 17 Sep 2010 17:32:09 -0700
From: Dinesh Bhandary <dbhandary@iii.com>
Reply-To: dbhandary@iii.com
Organization: Innovative Interfaces
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: files under pg_clog directories are missing
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  Hello Everybody -

Due to hardware crash we ran into issues where some blocks were 
corrupted and some files were missing.
I was able to get over the corrupted blocks ( errmsg - "invalid page 
header in block 12345  of realtion x") by setting
zero_damaged_pages=0 and running vacuum afterwards. Now I am running 
into situations where pg_clog files are missing (errmsg - "could not 
open pg_clog/0D0D). I have a backup which is quite old ( considering 
this as a last resort). Is there any other way to fix this problem?

I also created empty blocks to fool postgres, but there are so many of 
these file missing I was wondering if there a better/faster way to fix 
this problem.

Thanks.

Dinesh