starting with 9.3 i ve read on the EDB site about the possibility to switchover/switchback in a controlled manner. this way the current master is stopped, the slave is promoted to master and then since the old master's xlog position is behind the new master's, it can be directly connected as a new slave without the need of it being rebuilt and also without the need to use pg_rewind (since the xlog position hasnt moved forward). this is been possible after 2 commits, the one about the walsender sending all the xlogs to the slave when the master is being shut down and the second is about the timeline and how the slave can continue replicating when the timeline has changed. i have tested this many times and it has always worked. however, i find it strange that there is little awareness about it and pg professionals that i meet keep saying that the old master (new slave) needs to be rebuilt. could someone clarify if this works and if not why it could potentially fail? thank you in advance -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
