Re: 9.6 and fsync=off

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: 9.6 and fsync=off
Дата
Msg-id CAMsr+YF4JUTP6pOsCBMd9QTw9uCAfS8tzfku1O=73wqTU7Y9Aw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.6 and fsync=off  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: 9.6 and fsync=off  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Refactor pg_dump as a library?
Следующее
От:
Дата:
Сообщение: Re: About subxact and xact nesting level...