Re: Dumping and reloading stuff in 6.5.3

> 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