DDT wrote:
> According to manual, when you set "synchronous_commit" to on, the transaction commits will wait until
> master and slave flush the commit record of transaction to the physical storage, so I think even if
> turn off the fsync on master is safe for data consistency and data will not be lost if slave physical
> storage is not damaged.
I don't think that this is safe.
What if the master crashes and becomes corrupted as a consequence?
It will start sending corrupted data to the slave, which will
replay it, thus becoming corrupted itself.
Yours,
Laurenz Albe