Re: [GENERAL] Checkpoint request failed on version 8.2.1. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Date
Msg-id 5739.1168551162@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Checkpoint request failed on version 8.2.1.  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Re: [GENERAL] Checkpoint request failed on version 8.2.1.
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> Given that this could result in data loss, if this was to be done I'd
> very much want to see a way to disable it in a production environment.

Production environments are the same ones that won't be happy with
random checkpoint failures, either.

If we can't find a way to positively identify the deleted-file failures
then I think we've got to do something like this.

(You know, of course, that my opinion is that no sane person would run a
production database on Windows in the first place.  So the data-loss
risk to me seems less of a problem than the unexpected-failures problem.
It's not like there aren't a ton of other data-loss scenarios in that OS
that we can't do anything about...)

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Problem linking libecpg.5.3.dylib on OS X
Next
From: Magnus Hagander
Date:
Subject: Re: [GENERAL] Checkpoint request failed on version 8.2.1.