Re: DRDB risk factors?

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
Subject: Re: DRDB risk factors?
Date: 2007-05-31 07:31:58
Message-ID: 465E79EE.7040908@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Pundt 2007-05-31 07:46:56 Re: Make for PgSQL?
Previous Message Vincenzo Romano 2007-05-31 07:01:45 Make for PgSQL?