> Lincoln Yeoh wrote:
> >
> > Actually, say if I use postgresql on a journalling file system, would this
> > problem go away? e.g. I just lose data not written, but the database will
> > be at a known uncorrupted state, consistent with logs.
>
> Hmm, someone may have to correct me on this but last time I checked all
> the
> journalling filesystems currently available journalled *filesystem*
> *metadata*. IOW, after a crash, the filesystem structure will be intact,
> but your database maybe completely corrupt.
The buffers remain sitting in the file system buffers, not on disk in a
dick crash. That is the problem. Journaling does not change this.
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026