Hi Steve, Below is the scenario I want to achieve.
Warm-Standby Master ------------------------------------------------ DR-Master | | Replication built on Slony 2.1. | V Slave Given is actually setup of production, master/slave replication with log archive shipping using slony 2.1. And, Master with DR setup on same data center as DR-Master with Warm Standby configuration running fine with minimal lag. Q: What I want to achieve ? A: Swap the Masters. Means, now slave should receive events from DR-Master once it get promoted to Master as shown below Master DR Master | | X | Replication built on Slony 2.1. | | V | Slave <------| I believed, the DR-Master will have the same _slonyschema except the primary hostname. So, I have changed on both DR-Master & Slave of sl_path of primary hostname as fix. Assuming that, I have tested on my local box with below steps. 1. Stop slony between master,slave. 2. Take the _slonyschema dump of Master (In case any problem). 3. Promote the DR-Master. 4. update the _slonyschem.sl_path of column pa_conninfo with primary hostname on DR-Master & Slave. 5. Start slony daemons on DR-Master & Slave. Above steps won't work all the time, I did many times, very few times I could able to send events from DR-master to Slave with proper numbering of .SQL files.(log archives). I would request to recommend the correct procedure for swapping providers. -- Regards Raghav Blog: htt://raghavt.blogspot.com/
_______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general