Re: Sync Rep Design - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: Sync Rep Design
Date
Msg-id 4D1CF4E2.5000208@kaltenbrunner.cc
Whole thread Raw
In response to Re: Sync Rep Design  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Sync Rep Design  (Simon Riggs <simon@2ndQuadrant.com>)
List 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



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: small table left outer join big table
Next
From: Simon Riggs
Date:
Subject: Re: Sync Rep Design