Re: disaster recovery - Mailing list pgsql-general

From Bruce Momjian
Subject Re: disaster recovery
Date
Msg-id 200311270328.hAR3SO421583@candle.pha.pa.us
Whole thread Raw
In response to Re: disaster recovery  (Alex Satrapa <alex@lintelsys.com.au>)
List pgsql-general
Alex Satrapa wrote:
> Some caveats though:
> 1) Under Linux, if you have the file system containing the WAL mounted
> with asynchronous writes, "all bets are off". The *BSD crowd (that I
> know of) take great pleasure in constantly reminding me that if the
> power fails, my file system will be in an indeterminate state - things
> could be half-written all over the file system.

This is only a problem for ext2.  Ext3, Reiser, XFS, JFS are all fine,
though you get better performance from them by mounting them
'writeback'.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SCSI vs. IDE performance test
Next
From: Tom Lane
Date:
Subject: Re: postgres metadata