| From: | Michael Guerin <guerin(at)rentec(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: database corruption |
| Date: | 2004-06-24 19:33:33 |
| Message-ID: | 40DB2C8D.7080804@rentec.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Scott Marlowe wrote:
>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.
>
>
>
Switching from XFS to Reiserfs seems to have resolved our problems.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A Palmblad | 2004-06-24 20:10:46 | Re: database corruption |
| Previous Message | Manfred Koizar | 2004-06-24 18:20:43 | Re: sql |