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

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026