Hi all, I am relatively new to Postgres but after some some work
master/slave replication and failover working.
I can use a trigger file to promote my first slave to a new master but
where I am confused (from reading various docs) is quite how the second,
third and so on slaves know there is a new master and point to it for
replication etc.
One place says it should be automatic (I don't find that) and another
suggests you need to reconfigure each slave to point to the new Master (and
I guess restart each).
Can anyone clear this up?
Many Thanks,
steven