Re: Sync Rep Design

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Robert Treat <rob(at)xzilla(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Sync Rep Design
Date: 2010-12-30 21:08:50
Message-ID: 4D1CF4E2.5000208@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/30/2010 10:01 PM, Simon Riggs wrote:
> On Thu, 2010-12-30 at 15:51 -0500, Robert Treat wrote:
>
>> Still, one thing that has me concerned is that in the case of two
>> slaves, you don't know which one is the more up-to-date one if you
>> need to failover. It'd be nice if you could just guarantee they both
>> are...
>
> Regrettably, nobody can know that, without checking.

how exactly would you check? - this seems like something that needs to
be done from the SQL and the CLI level and also very well documented
(which I cannot see in your proposal).

Stefan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-12-30 21:10:00 Re: Sync Rep Design
Previous Message Dimitri Fontaine 2010-12-30 21:05:09 Re: small table left outer join big table