| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Doug McNaught <doug(at)mcnaught(dot)org> |
| Cc: | Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>, Jason Tesser <JTesser(at)nbbc(dot)edu>, "Pgsql (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: disaster recovery |
| Date: | 2003-11-27 03:41:17 |
| Message-ID: | 19804.1069904477@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Doug McNaught <doug(at)mcnaught(dot)org> writes:
> Alex Satrapa <alex(at)lintelsys(dot)com(dot)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 ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randolf Richardson | 2003-11-27 04:47:42 | Re: Index on array element |
| Previous Message | Tom Lane | 2003-11-27 03:31:45 | Re: postgres metadata |