Re: Humor me: Postgresql vs. MySql (esp. licensing) - Mailing list pgsql-general

From Vivek Khera
Subject Re: Humor me: Postgresql vs. MySql (esp. licensing)
Date
Msg-id x7ad88q2yd.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Re: Humor me: Postgresql vs. MySql (esp. licensing)  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Humor me: Postgresql vs. MySql (esp. licensing)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Humor me: Postgresql vs. MySql (esp. licensing)  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
>>>>> "sm" == scott marlowe <scott.marlowe> writes:

>> will ungracefully kill the DB process(es).  Doesn't matter what DB (or
>> any other application) you're running, you *can* lose data this way.

sm> While it is possible to lose a non-committed transaction, WAL prevents the
sm> database from becoming corrupted.  Assuming proper fsyncing of your hard
sm> drives (i.e. SCSI, or IDE with write cache disabled)

So you're saying it is not possible to corrupt the WAL if the process
is ungracefully killed by the OS?

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-general by date:

Previous
From: "Mike Leahy"
Date:
Subject: Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
Next
From: Bruce Momjian
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)