On 06/16/11 1:31 AM, AI Rumman wrote:
When I manually create the C:\\pg\\stopreplication\\standby.txt' file, then it is working. That is, B is becoming the master. So, my question is, how this trigger file should be created so that B will become master automatically as soon as A goes down?
you need cluster management software, such as Heartbeat (on linux) or Veritas Cluster Service (on various operating systems) configured to detect system failure, and reconfigure the slave to be the master. This software also generally is used to manage things like the shared IP
really really REALLY important is what to do when the failed original master is brought back up. it can NOT be allowed to wake up thinking its still a master since its lacking any updates since it went down, instead it has to be reconfigured to be a new slave.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
