| From: | Marco Colombo <pgsql(at)esiway(dot)net> |
|---|---|
| To: | Andrew Hall <temp02(at)bluereef(dot)com(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Lost rows/data corruption? |
| Date: | 2005-02-15 15:58:09 |
| Message-ID: | Pine.LNX.4.61.0502151458430.18326@Megathlon.ESI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 15 Feb 2005, Andrew Hall wrote:
>
>
>>> It sounds like a mess, all right. Do you have a procedure to follow to
>>> replicate this havoc? Are you sure there's not a hardware problem
>>> underlying it all?
>>>
>>> regards, tom lane
>>>
>
> We haven't been able to isolate what causes it but it's unlikely to be
> hardware as it happens on quite a few of our customer's boxes. We also use
> XFS on linux 2.6 as a file system, so the FS should be fairly tolerant to
> power-outages. Any ideas as to how I might go about isolating this? Have you
> heard any other reports of this kind and suggested remedies?
Are you running with fsync = off? and did the hosts experience any
power-outage recently?
.TM.
--
____/ ____/ /
/ / / Marco Colombo
___/ ___ / / Technical Manager
/ / / ESI s.r.l.
_____/ _____/ _/ Colombo(at)ESI(dot)it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ruben Oliveira | 2005-02-15 16:04:42 | problem with dots in order by |
| Previous Message | Pavel Stehule | 2005-02-15 15:42:08 | Re: Trading off large objects (arrays, large strings, |