Skip site navigation (1) Skip section navigation (2)

Re: database corruption

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Michael Guerin" <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: database corruption
Date: 2004-06-11 21:38:13
Message-ID: 1086989893.31155.5.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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.


In response to

Responses

pgsql-novice by date

Next:From: M. BastinDate: 2004-06-11 22:32:08
Subject: Re: Character encoding in database dumps
Previous:From: Michael GuerinDate: 2004-06-11 20:16:30
Subject: database corruption

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group