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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
