Re: Demoting master to slave without an rsync...is it safe? - Mailing list pgsql-general

From Chris Redekop
Subject Re: Demoting master to slave without an rsync...is it safe?
Date
Msg-id CAC2SuRK=upbuAMPBwQg6dHr6mWK1byjR_MaU=ZACx72DT=yjrg@mail.gmail.com
Whole thread Raw
In response to Re: Demoting master to slave without an rsync...is it safe?  (Alex Lai <alai@sesda2.com>)
Responses Re: Demoting master to slave without an rsync...is it safe?  (Alex Lai <alai@sesda2.com>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Advice on HA option
Next
From: Merlin Moncure
Date:
Subject: Re: conditional insert