Re: Replication and fsync

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Replication and fsync
Дата
Msg-id CAMkU=1y=URZpPfzP_gdnHOQNkFV3AsG_=WT+Cw59PnctBAPC3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Replication and fsync  (maillists0@gmail.com)
Список pgsql-general
On Wed, Oct 23, 2013 at 6:39 PM, <maillists0@gmail.com> wrote:
Newb question.

I'm running 9.1 with a slave using streaming replication. A coworker wants to turn off fsync on the master and insists that the slave will still be in a usable state if there is a failure on the master.

This would only be safe if you made sure to shoot the master in the head after a crash.  If the master ever comes back up again, through automatic recovery or through start-up scripts, it could start feeding corrupt WAL records to the slave, corrupting it as well.

Cheers,

Jeff

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: PostgreSQL Point In Time Recovery
Следующее
От: Robert James
Дата:
Сообщение: Re: Count of records in a row