Re: [HACKERS] The dangers of "-F"

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] The dangers of "-F"
Дата
Msg-id 199906222238.SAA28561@candle.pha.pa.us
обсуждение исходный текст
Ответ на The dangers of "-F"  (Don Baccus <dhogaza@pacifier.com>)
Ответы Re: [HACKERS] The dangers of "-F"
Список pgsql-hackers
> So obviously I'm really looking forward to the day
> when a read-only select doesn't trigger a write to
> pg_log (which apparently is the problem?) and an
> "fsynch the world" operation.
> 
> In the interim, just how dangerous is it to run with
> "-F"? 
> 
> Am I risking corruption of the db and a total rebuild,
> or will I just lose transactions but be left with a
> consistent database if the machine goes down?

No Fsync is only dangerous if your OS or hardware crashes without
flushing the disk. Anything else is unaffected, and is just as reliable.

The database could be inconsistent, in the sense that partial
transactions are recorded as completed.

I think it is a major issue too.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] money data type and conversions
Следующее
От: Duane Currie
Дата:
Сообщение: Re: [HACKERS] money data type and conversions