On 4/23/19 9:47 AM, Peter Eisentraut wrote:
> On 2019-04-23 14:31, Joe Conway wrote:
>> Looks like you dropped the advice WRT the asynchronous mount option.
>> Isn't that is still relevant?
>
> I don't think that advice was correct. An async mounted NFS file system
> will flush data on fsync, which is what one wants.
>
I don't think so. Not sure if you have an account at Red Hat, but this
ticket covers it:
https://access.redhat.com/solutions/48199
Here is the relevant part of the solution as written by Red Hat:
"Finally, note that, for writes over NFS, a subsequent commit request
from the NFS client at file close time, or at
fsync() time, will force the server to write any previously unwritten
data/metadata to the disk, and the server will not reply to the client
until this has been completed, as long as sync behavior is followed. If
async is used, the commit is essentially a no-op, since the server once
again lies to the client, telling the client that the data has been sent
to stable storage. This again exposes the client and server to data
corruption, since cached data may be discarded on the client due to its
belief that the server now has the data maintained in stable storage."
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development