Yes, but I don't understand at all where this conversation is going, or how it's relevant. I have fail-over working perfectly fine.....my original question was: is it safe to bring a former master back up as a slave without doing a base-backup first? (using
recovery_target_timeline='latest')
On Wed, Sep 7, 2011 at 6:28 AM, Alex Lai
<alai@sesda2.com> wrote:
Chris Redekop wrote:
I have two questions:
(1) Did you set recovery_target_timeline='latest' in both master
and slave?
Yes....but it's in recovery.conf so it only really applies to whichever server is currently the slave...
(2) Did you make any changes after promote the slave to be master?
Yes, some....however I'm not sure I've done enough changes to have the slave rotate+archive an xlog before bringing the old master back up as a slave....I would assume that wouldn't make a difference but it's something to test I guess....