Aaron Randall wrote: > Hi All! > > I have a question with regards to promoting a slave. In my current setup, I > have two nodes, the Master and the Slave. Replication works perfectly, > however > I need to plan for outages of the Master. In testing, if I kill the master > server, I need a way (manual intervention is fine) to get the slave up and > running so you can access the database. Currently if I kill the Master and > stop the Slon processes on the slave, I can read from the database, but can > still not write to it. I found the script on this page > (http://www.linuxjournal.com/article/7834 under section "promote.sh") but I > can't seem to get it to work. Any ideas? > > In order to promote slave to master, there are two methods:
1. If the master is "dead", then you use FAIL OVER, discarding it. Furthermore, if you only have two nodes, there's not much to preserve, so I'd be inclined to simply clean out Slony-I stuff via UNINSTALL NODE. 2. If the master is *not* to become dead, then you want to use MOVE SET to request that the origin be moved to the other node. This requires that both nodes (indeed, it more or less requires that *ALL* nodes in the cluster) be up. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
