Re: database corruption - Mailing list pgsql-novice

From Scott Marlowe
Subject Re: database corruption
Date
Msg-id 1086989893.31155.5.camel@localhost.localdomain
Whole thread Raw
In response to database corruption  (Michael Guerin <guerin@rentec.com>)
Responses Re: database corruption
List pgsql-novice
On Fri, 2004-06-11 at 14:16, Michael Guerin wrote:
> Hi,
>
>     We recently switch over from Solaris to Linux and we've been
> experiencing a couple database corruptions problems.  We're using the
> 2.6 kernel and a XFS file system, in case there are any known problems
> with this setup.
>
> It's my understanding that these errors are typically b/c of hardware
> problems, so we're in the process of checking the disk.  However, are
> there other things that I should look to find out what's going on?   The
> table that was corrupted earlier this week was dropped and  recreated,
> but it was corrupted again sometime last night.  The table is pretty
> active, about 10GB are inserted and deleted every day.

Be sure and test your memory too.  And if you have a hardware RAID
controller, sometimes they can be slightly broken and cause random
corruption.


pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: database corruption
Next
From: "M. Bastin"
Date:
Subject: Re: Character encoding in database dumps