Re: Replication and fsync - Mailing list pgsql-general

From Jeff Janes
Subject Re: Replication and fsync
Date
Msg-id CAMkU=1y=URZpPfzP_gdnHOQNkFV3AsG_=WT+Cw59PnctBAPC3Q@mail.gmail.com
Whole thread Raw
In response to Replication and fsync  (maillists0@gmail.com)
List 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 by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: PostgreSQL Point In Time Recovery
Next
From: Robert James
Date:
Subject: Re: Count of records in a row