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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
