Hello -
I'm trying to implement Streaming replication with several Hot-Standby
servers and floating IP for the Master Server. I mean when Master
server fails IP gets switched to the new Master and all standby
servers start receiving log data from the new Master. My problem
though is timelines. Whenever Stansby server gets triggered from
Stansby role to Master role it increases Timeline and that kind of
invalidates all other Standbys. They start to complain on mismatching
Timeline. The only way to fix them is to switch new Master into Backup
mode and resync al Standbys. On other hand if I don't use trigger file
and just stop Standby, remove recovery.conf file and start it back,
all other Standbys keep working well, but I'm not sure how safe is
this strategy. So the question if it's possible to avoid increasing
Timelines when trigger file is used.
Thanks.
--
Serge Dubrouski.