Re: why not kill -9 postmaster - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: why not kill -9 postmaster
Date
Msg-id 7be3f35d0610200637p747f81e5s32af230419a9dc05@mail.gmail.com
Whole thread Raw
In response to Re: why not kill -9 postmaster  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
>
> If your server is changing the data file on disk and you pull the power
> cord, what chance do you expect of reading that data file again?

1.  That's what we have WAL for.  The only thing that can really kill
you is the use of non-battery-backed write cache.

Just for information: I had to suffer numerous BOS (blue screen of death) on an W2k3 Server running PostgreSQL 8.0 and 8.1 for Windows.

Every time the database restarted without data loss and without operator invention.

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

pgsql-general by date:

Previous
From: Andreas Seltenreich
Date:
Subject: Re: c function returning high resolution timestamp
Next
From: Ray Stell
Date:
Subject: Re: why not kill -9 postmaster