Re: Losing records when server hang

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "lec" <limec(at)streamyx(dot)com>
Cc: "Chris Travers" <chris(at)metatrontech(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Losing records when server hang
Date: 2004-08-11 06:14:37
Message-ID: 1092204877.27166.354.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2004-08-10 at 19:30, lec wrote:
> Chris Travers wrote:

> The first hardware that got replaced was the SCSI controller. After
> that there were still hardware "hanging" and eventually the system
> engineers replaced the whole server and they weren't sure what the fault
> was. The lost transactions happened not on the first server hang. I'm
> more curious to know why the transactions in the middle got lost but the
> last transaction was there.

With questionable hardware (failing memory, scsi / raid controller,
etc.) all failure modes are pretty much possible. PostgreSQL is good,
but it can't make up for bad hardware.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 马建霞 2004-08-11 06:42:06 ask for help about postgresql
Previous Message Christian Traber 2004-08-11 05:53:20 Re: error moving table to tablespace (8.0 beta win32 )