Doing switchover and failover with Slony-I
http://slony1.projects.postgresql.org/slony1-1.2.6/doc/adminguide/failover.html
http://slony1.projects.postgresql.org/slony1-1.2.6/doc/adminguide/failover.html
http://www.onlamp.com/pub/a/onlamp/2005/03/17/slony_changes.html
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html