Re: Sync Rep at Oct 5 - Mailing list pgsql-hackers

From Steve Singer
Subject Re: Sync Rep at Oct 5
Date
Msg-id 4CADB318.8000900@ca.afilias.info
Whole thread Raw
In response to Re: Sync Rep at Oct 5  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Sync Rep at Oct 5
List pgsql-hackers
On 10-10-07 05:52 AM, Fujii Masao wrote:
> On Wed, Oct 6, 2010 at 4:06 PM, Simon Riggs<simon@2ndquadrant.com>  wrote:
>> The problem is how much WAL is stored on (any) node. Currently that is
>> wal_keep_segments, which doesn't work very well, but I've seen no better
>> ideas that cover all important cases.
>
> What about allowing the master to read and send WAL from the archive?
>
> Regards,

Then you have to deal with telling the archive how long it needs to keep 
WAL segments because the master might ask for them back.  If the archive 
is remote from the master then you have some extra network copying going 
on.  It would be better to let the slave being reconfigured to read the 
missing WAL from the archive.





pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: todo point: plpgsql - scrollable cursors are supported
Next
From: Markus Wanner
Date:
Subject: Re: Issues with Quorum Commit