Re: DRDB risk factors? - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: DRDB risk factors?
Date
Msg-id 465E79EE.7040908@theendofthetunnel.de
Whole thread Raw
In response to DRDB risk factors?  (Kevin Kempter <kevin@kevinkempterllc.com>)
List pgsql-general
On 30.05.2007 23:31, Kevin Kempter wrote:
> per considering DRDB as a replication solution in a failed master node
> scenario, is there a risk of loosing not only in-flight transactions but alos
> un-sync'd buffer-pool dirty pages?
>
> If so, how might I minimize this risk ?

If you have DRBD using protocol C and fsync enabled in PG you don't lose
a single commit. That is true for any ACID conform application.

Be sure to you have your hardware right. Running DRBD on fsync/fua lying
hardware is committing suicide. I can't stress that enough.


--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Make for PgSQL?
Next
From: Thomas Pundt
Date:
Subject: Re: Make for PgSQL?