Re: disaster recovery

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: disaster recovery
Дата
Msg-id 200311270328.hAR3SO421583@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: disaster recovery  (Alex Satrapa <alex@lintelsys.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: SCSI vs. IDE performance test
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres metadata