Replication and fsync

From: maillists0(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Replication and fsync
Date: 2013-10-24 01:39:21
Message-ID: CAB+OxSBeHZ15u0baKKEuNf2EgCy-Szu3tVcCq2+_awi2V60fYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. We all know that
turning off fsync is a bad idea, but I was under the impression that the
fsync setting would be replicated to the slave, making it useless as a
backup in this scenario. Am I wrong? If I'm wrong, is there still danger to
the slave in this kind of setup? Can I count on it remaining unharmed if
the master suffers unrecoverable corruption?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2013-10-24 04:10:36 PostgreSQL Point In Time Recovery
Previous Message Andy Colson 2013-10-23 23:11:08 Re: Monitoring number of backends