Re: disaster recovery - Mailing list pgsql-general

From Doug McNaught
Subject Re: disaster recovery
Date
Msg-id 873cca7x42.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: disaster recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: disaster recovery  (Alex Satrapa <alex@lintelsys.com.au>)
Re: disaster recovery  (Marco Colombo <marco@esi.it>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Doug McNaught <doug@mcnaught.org> writes:
>> Alex Satrapa <alex@lintelsys.com.au> writes:
>>> 1) Under Linux, if you have the file system containing the WAL mounted
>>> with asynchronous writes, "all bets are off".
>> ...
>> Even with ext2, WAL files are preallocated and PG calls fsync() after
>> writing, so in practice it's not likely to cause problems.
>
> Um.  I took the reference to "mounted with async write" to mean a
> soft-mounted NFS filesystem.  It does not matter which OS you think is
> the one true OS --- running a database over NFS is the act of someone
> with a death wish.  But, yeah, soft-mounted NFS is a particularly
> malevolent variety ...

I took it as a garbled understanding of the "Linux does async metadata
updates" criticism.  Which is true for ext2, but was never the
show-stopper some BSD-ers wanted it to be.  :)

-Doug

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: What is WAL used for?
Next
From: Horák Daniel
Date:
Subject: Re: Open source data modeling tools for PostgreSQL