Horton

Re: Dumping and reloading stuff in 6.5.3

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
Cc: Lincoln Yeoh <lylyeoh@mecomb.com>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, pgsql-general@postgresql.org
Date: 2000-05-15T18:32:45Z
Lists: pgsql-hackers 
> 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