From: Aaron Bono <postgresql@aranya.com>
To: Michael Monnerie <michael.monnerie@it-management.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: System in Recovery Mode
Date: Mon, 25 Feb 2008 15:19:45 -0600
Message-ID: <bf05e51c0802251319m36af9badt2fc75c470e81e0e0@mail.gmail.com> (raw)
In-Reply-To: <200802252148.47760@zmi.at>
References: <bf05e51c0802250611y401e1d1bs3cd4e789e917f9f1@mail.gmail.com>
<1203958095.4252.79.camel@ebony.site>
<bf05e51c0802250859q4cb471fcs345f1ba2640ed213@mail.gmail.com>
<200802252148.47760@zmi.at>
On Mon, Feb 25, 2008 at 2:48 PM, Michael Monnerie <
michael.monnerie@it-management.at> wrote:
> On Montag, 25. Februar 2008 Aaron Bono wrote:
> > We did have a hard drive problem (errors on the drive) in the past
> > and they had to swap out a drive. It is a RAID configuration so no
> > backup/restore was necessary.
>
> Even with a RAID system, a broken hard drive that doesn't show that it's
> broken can cause severe data destroying: We've had this several times
> already, with different RAID and drive combinations, SATA and SCSI,
> doesn't matter. The symptom was that you write data to the drive, it
> says OK, but upon reading you receive other data than you wrote. Even
> RAID 1/5/6 doesn't help you here.
>
> Doesn't mean you have the same, but from what you wrote I just wanted to
> inform you that it's a fact that a single broken drive can destroy even
> a RAIDs data very nasty.
>
> mfg zmi
>
>
If I do a pg_dump from this potentially "bad" database and then use the
output to do a restore to a new DB on another server, aside from having some
data corrupted, would we be able to recover from this problem? If not, what
could I do to "fix" the data so the database stops having issues?
Thanks!
Aaron
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
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: postgresql@aranya.com, michael.monnerie@it-management.at
Subject: Re: System in Recovery Mode
In-Reply-To: <bf05e51c0802251319m36af9badt2fc75c470e81e0e0@mail.gmail.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