| From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
|---|---|
| To: | Massoud <footballist(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data Corruption |
| Date: | 2002-08-04 03:46:09 |
| Message-ID: | Pine.LNX.4.44.0208032343420.29827-100000@cm-lcon1-46-187.cm.vtr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masaru Sugawara | 2002-08-04 04:07:29 | Re: Serials: removing the holes? (consecutive) |
| Previous Message | Tom Lane | 2002-08-04 03:44:01 | Re: getpid() function |