Re: The database system is in recovery mode - Mailing list pgsql-admin

From dalgoda@ix.netcom.com (Mike Castle)
Subject Re: The database system is in recovery mode
Date
Msg-id qboooxp1b.ln2@thune.mrc-home.org
Whole thread Raw
In response to The database system is in recovery mode  (Trevor Astrope <astrope@e-corp.net>)
Responses Re: The database system is in recovery mode
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Upgrade to RH9.....Help....PostgreSQL newbie
Next
From: Terence Ng
Date:
Subject: Multilingual database