Re: Synchronous replication & Hot standby patches

Simon Riggs wrote:
> On Wed, 2009-02-25 at 00:51 +0900, Fujii Masao wrote:
> 
>> On Tue, Feb 24, 2009 at 3:47 PM, K, Niranjan (NSN - IN/Bangalore)
>> <niranjan.k@nsn.com> wrote:
>>> Could you please let me know what are the outstanding features that are still to be developed in the respective
patches?
>>>
>>> I'am currently referring the wiki: "Todo and Claim" for NTT and for HotStandby, i see that almost all issues are
closed.Are there any features / refactoring / bugs still need to be fixed.
 
>> At least I'm planning to work on the following two items of Synch Rep for v8.5.
>> Of course, Synch Rep works fine without these features.
> 
>> - Add new feature which transfers all WAL records via the direct connection
>>   between the primary and the standby. In other words, get rid of
>>   file-based log shipping part from the patch.
>>   http://archives.postgresql.org/message-id/496B9495.4010902@enterprisedb.com
> 
> Please bear in mind my strong objection to this. Attempting to transfer
> all data via a single connection destroys VLDB usage of this feature. So
> for me its just additional code for ease-of-use in the simplest case,
> not code replacement.

Presumably we'll keep the capability to restore from a backup and 
restore from WAL archive as well, when those are available. Keeping that 
capability shouldn't add many lines of code.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com