From: Enrico <scotty@linuxtime.it>
To: pgsql-admin@postgresql.org
Subject: Disaster recovery: pg_class
Date: Fri, 13 Oct 2006 11:29:29 +0200
Message-ID: <20061013112929.1cbb7b9e@mypc.ricordatasystem.info> (raw)
After a system crash, I have this error:
SELECT * from mytable;
WARNING: could not write block 14 of 1663/1743558/1259
DETAIL: Multiple failures --- write error may be permanent.
ERROR: xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0
CONTEXT: writing block 14 of relation 1663/1743558/1
I searched for 1259 oid, and I found that 1259 links to pg_class table.
Is there any way to restore my pg_class table?
Thanks in advantage.
Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: scotty@linuxtime.it
Subject: Re: Disaster recovery: pg_class
In-Reply-To: <20061013112929.1cbb7b9e@mypc.ricordatasystem.info>
References: <20061013112929.1cbb7b9e@mypc.ricordatasystem.info>
* 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