Re: Losing records when server hang

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
Cc: "Alvaro Herrera Munoz" <alvherre(at)dcc(dot)uchile(dot)cl>, "lec" <limec(at)streamyx(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Losing records when server hang
Date: 2004-08-09 05:44:19
Message-ID: 6269.1092030259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Scott Marlowe" <smarlowe(at)qwest(dot)net> writes:
> On Sun, 2004-08-08 at 21:26, Alvaro Herrera Munoz wrote:
>> If this is only one backend, then I'd love to see how did he do that.

> Me too :-)

Given a disk drive that lies about write complete (which is to to say,
most consumer-grade IDE gear), it's at least theoretically possible.
But it doesn't sound real likely, especially if the machine didn't
actually lose power.

I was wondering what he meant by "hang", as well as what he meant by
"commit". The overall lack of detail in the report is notable.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-08-09 08:01:57 Re: constraint expression
Previous Message Scott Marlowe 2004-08-09 05:33:33 Re: PostgreSQL 8.0 Feature List?