Re: 9.6 and fsync=off - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: 9.6 and fsync=off
Date
Msg-id CAMsr+YF4JUTP6pOsCBMd9QTw9uCAfS8tzfku1O=73wqTU7Y9Aw@mail.gmail.com
Whole thread Raw
In response to Re: 9.6 and fsync=off  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: 9.6 and fsync=off  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2 May 2016 at 22:07, Robert Haas <robertmhaas@gmail.com> wrote:
 

I also think that it would be a swell idea to detect whether a system
has ever crashed with fsync=off, and do something about that, like
maybe bleat on every subsequent startup for the lifetime of the
cluster.

Yes. Very, very yes.

That would've made my life considerably easier on a few occasions now.

It shouldn't take much more than a new pg_control field and a test during recovery.

Should TODO this, but since that's sometimes where ideas go to die, I'm going to see if I can hack this out soon as well.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Refactor pg_dump as a library?
Next
From:
Date:
Subject: Re: About subxact and xact nesting level...