Re: Demoting master to slave without an rsync...is it safe?

[Chris Redekop <chris@xxxxxxxxxxxx>]

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@xxxxxxxxxx> 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....

Did you set trigger_file in recovery?  That is the required step to switch slave to master.   I set my log rotate+archive to 15 minutes.  When I touch fail over file, it mostly like force it to rotate+archive.

--
Best regards,


Alex Lai
OMI SIPS DBA ADNET Systems , Inc. 7515 Mission Drive, Suite A100 Lanham, MD 20706 301-352-4657 (phone) 301-352-0437 (fax) alai@xxxxxxxxxx