| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Alex Satrapa <alex(at)lintelsys(dot)com(dot)au> |
| Cc: | 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:28:24 |
| Message-ID: | 200311270328.hAR3SO421583@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-27 03:31:45 | Re: postgres metadata |
| Previous Message | Christopher Browne | 2003-11-27 03:23:14 | Re: Happy Thanksgiving! |