Re: Data Corruption - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Data Corruption
Date
Msg-id Pine.LNX.4.44.0208032343420.29827-100000@cm-lcon1-46-187.cm.vtr.net
Whole thread Raw
In response to Data Corruption  (Massoud <footballist@yahoo.com>)
List pgsql-general
Massoud dijo:

> I have been getting minor (repairable) data corruption on a
> regular basis.  This is where some field's contents get
> partially changed to funny characters.
[...]

> I seriously considering downgrading to lower release of
> postgres.

Don't do that.  The cases where corruption has appeared in data until
now in recent releases (say from 7.0) have always had something to do
with bad hardware; RAM, mostly.

So you better start testing memory.  Probably memtest86 can help you.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Saca el libro que tu religion considere como el indicado para encontrar la
oracion que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclos)


pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: Serials: removing the holes? (consecutive)
Next
From: Masaru Sugawara
Date:
Subject: Re: Serials: removing the holes? (consecutive)