Re: The database system is in recovery mode

In article <20030502141444.GC13419@libertyrms.info>,
Andrew Sullivan  <andrew@libertyrms.info> wrote:
>Neither, assuming you have good hardware and you're using fsync.  WAL
>is there precisely to make the system crash safe.  (Of course, if
>it's sitting on an ext2 partition and the system goes down hard, you
>have a different batch of problems.  But WAL+fsync protects you from
>postmaster crashes, and machine crashes if your filesystem is
>crash-safe.)


You seem to be implying that ext2+fsync is not machine crash safe.  Is this
really what you are trying to say?

If so, could you point to docs that verify that?

I could definitely see where ext2 without fsync would leave the system in
an strange state, but with fsync it should be fine.

mrc

--
     Mike Castle      dalgoda@ix.netcom.com      www.netcom.com/~dalgoda/
    We are all of us living in the shadow of Manhattan.  -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc