Re: database corruption

Поиск
Список
Период
Сортировка
От Michael Guerin
Тема Re: database corruption
Дата
Msg-id 40DB2C8D.7080804@rentec.com
обсуждение исходный текст
Ответ на Re: database corruption  ("Scott Marlowe" <smarlowe@qwest.net>)
Список 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.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: sql
Следующее
От: "A Palmblad"
Дата:
Сообщение: Re: database corruption