Re: The database system is in recovery mode

Поиск
Список
Период
Сортировка
От dalgoda@ix.netcom.com (Mike Castle)
Тема Re: The database system is in recovery mode
Дата
Msg-id qboooxp1b.ln2@thune.mrc-home.org
обсуждение исходный текст
Ответ на The database system is in recovery mode  (Trevor Astrope <astrope@e-corp.net>)
Ответы Re: The database system is in recovery mode
Список 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 по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: Upgrade to RH9.....Help....PostgreSQL newbie
Следующее
От: Terence Ng
Дата:
Сообщение: Multilingual database