Hi All,
Let's consider the following case: WAL segments from a master have
been shipped to N warm standby servers, and now the master fails.
Using this or that mechanism, one of the warm standbys takes over and
becomes the new master. Now the question is what to do with the other
N-1 warm standbys. By the failure, all N warm standbys were the same
exact copies of the master. So at least in theory, the N-1 warm
standbys left can be fed with WAL segments from the new master. Do
you think it will work in practice? Are there any pitfalls?
Thanks!
Yar