Re: [GENERAL] Hot Standby switchover

2010-06-22 Thread Shoaib Mir
On Tue, Jun 22, 2010 at 7:08 PM, Dimitri Fontaine wrote: > Now, you can change the primary_conninfo on C so that it connects to > B. I guess that means a restart. Note that you only want to do that once > server B is the new master, so has been triggered as such. That means a > change of TimeLine,

Re: [GENERAL] Hot Standby switchover

2010-06-22 Thread Dimitri Fontaine
Hi, Shoaib Mir writes: > Now Hot-Standby is setup like this... > > A --> B  > A --> C > > Now if I will like to do a switch so as to make B the new master and have my > replication look like this: > > B --> C  > B --> A > > Where are the steps I need for doing so? First, you need a common archi

[GENERAL] Hot Standby switchover

2010-06-22 Thread Shoaib Mir
Hi All, Just been trying to learn hot-standby and couldn't figure out a solution to something like this while doing a switchover: I have three nodes where A = Master B = Slave1 C = Slave2 Now Hot-Standby is setup like this... A --> B A --> C Now if I will like to do a switch so as to make B t