| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
| Cc: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dumping and reloading stuff in 6.5.3 |
| Date: | 2000-05-15 18:32:45 |
| Message-ID: | 200005151832.OAA20658@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Felipe Zirbes | 2000-05-15 18:52:17 | Where is it? |
| Previous Message | Jeff Hoffmann | 2000-05-15 18:26:59 | Re: rtree indexes aren't being used with 7.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank G Hahn | 2000-05-15 18:43:16 | FTP-sever ftp.postgresql.org unable to get dir-list ? |
| Previous Message | Bruce Momjian | 2000-05-15 18:14:21 | Re: Proposal: replace no-overwrite with Berkeley DB |