From: Dinesh Bhandary <dbhandary@iii.com>
To: pgsql-admin@postgresql.org
Subject: files under pg_clog directories are missing
Date: Fri, 17 Sep 2010 17:32:09 -0700
Message-ID: <4C940889.3000505@iii.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dbhandary@iii.com
Subject: Re: files under pg_clog directories are missing
In-Reply-To: <4C940889.3000505@iii.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox