Greetings all,<br><br>I have a setup based on two virtualised server systems with postgres 8.4 and slony-i version 2.0.2 sources compiled insite. Both are running Ubuntu server edition. One system acts as a database fron-end with the database set as master, while the other is a slave system aimed at replicating databases from multiple masters.<br>
<br>In my scenario I want to use the slave system merely as a backup resource, hence if the master server dies, instead of promoting the slave to a master, I want to recreate the master system from scratch, dumping the slave's database replica into it, repromote it to a master system, and link it to the slave server with minimum effort.<br>
<br>I am aware this is not the most common setup, and I can't find a recipe about how to perform this transition. I've tried with failover and switchover without success.<br><br>Any help on the easiest way to accomplish this greatly appreciated.<br>
<br>Thanks,<br>Albert<br><br>