Re: PostgreSQL clustering (shared disk)

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org, drbd-user(at)lists(dot)linbit(dot)com
Subject: Re: PostgreSQL clustering (shared disk)
Date: 2007-08-17 14:45:39
Message-ID: 20070817144539.GE13741@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rajaram J 2007-08-17 14:47:34 Where are the Server error logs
Previous Message Phoenix Kiula 2007-08-17 14:32:07 Re: Some frustrations with admin tasks on PGSQL database