Re: Synchronization levels in SR - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Synchronization levels in SR
Date
Msg-id 4C865085.60500@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Synchronization levels in SR  (Markus Wanner <markus@bluegap.ch>)
Responses Re: Synchronization levels in SR  (Markus Wanner <markus@bluegap.ch>)
List pgsql-hackers
Markus Wanner wrote:
> On 09/07/2010 02:16 PM, Robert Haas wrote:
>> practice, this means that the master and standby need to compare notes
>> on the ending WAL location and whichever one is further advanced needs
>> to stream the intervening records to the other.
> 
> Not necessarily, no. Remember that the client didn't get a commit
> confirmation. So reverting might also be a correct solution (i.e. not
> violating the durability constraint).

In that situation, wouldn't it be possible that a different client
queried the slave and already saw the result of that transaction
which would later be rolled back?



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: can we publish a aset interface?
Next
From: Tom Lane
Date:
Subject: Re: Synchronous replication - patch status inquiry