Re: PostgreSQL clustering (shared disk) - Mailing list pgsql-general

From Magnus Hagander
Subject Re: PostgreSQL clustering (shared disk)
Date
Msg-id 20070817144539.GE13741@svr2.hagander.net
Whole thread Raw
In response to Re: PostgreSQL clustering (shared disk)  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
On Fri, Aug 17, 2007 at 04:19:57PM +0200, Hannes Dorbath wrote:
> On 17.08.2007 15:59, Tom Lane wrote:
> >On the other side of the coin, I have little confidence in DRBD
> >providing the storage semantics we need (in particular guaranteeing
> >write ordering).  So that path doesn't sound exactly risk-free either.
>
> To my understanding DRBD provides this. I think a discussion about that
> with the DRBD developers would be very useful for many users searching
> for a solution to replicate PostgreSQL, so I'm cross posting this to
> DRBD list. Maybe you can make clear in detail what requirements
> PostgreSQL has.

It does, AFAIK, if yuo configure it properly. I think it's the "protocol"
parameter you need to set to C which is the slowest, but it's the only one
that waits for the block to hit *both* disks.

//Magnus


pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Some frustrations with admin tasks on PGSQL database
Next
From: "Rajaram J"
Date:
Subject: Where are the Server error logs