On 07/08/2009 09:59 AM, Kevin Grittner wrote:
Dimitri Fontaine<dfonta...@hi-media.com> wrote:
4. sync: slave is no more lagging, it's applying the stream as it
gets it, either as part of the master transaction or not
depending on the GUC settings
I think the interesting bit is when you're at this point and the
connection between the master and slave goes down for a couple days.
How do you handle that?
Been following with great interest...
If the updates are not performed at a regular enough interval, the slave
is not truly a functioning standby. I think it's a different problem
domain, probably best served by the existing pg_standby support? If the
slave can be out of touch with the master for an extended period of
time, near real time logs provide no additional benefit over just
shipping the archived WAL logs and running the standby in continuous
recovery mode?
Cheers,
mark
--
Mark Mielke<m...@mielke.cc>
