Hi, I have set up replication between 2 PostgreSQL servers using SLONY - I. One is a Master and the 2nd one is a Slave. I am planning to add more Slave servers to this setup. In effect the plan is to set up a chain (i.e. Slave 1 subscribes to Master, Slave 2 subscribes to Slave 1, Slave 3 subscribes to Slave 2 ... and so on).
I have the following questions: 1. If one of the slave node goes down, will Slony be able to automatically detect that it has gone down? If no, what is the best way to receive notification when one or more slave goes down? 2. If one of the slave node goes down, will replication continue over to the next Slave(s) in the chain? (ie. if Slave 2 goes down, would the replication automatically go from Slave 1 to Slave 3 to keep the chain running?) If no, what needs to be done to get the chain to continue? 3. If a slave node goes down, what is the process after it is back on-line to reset the chain and synchronize the data? (i.e. if Slave 2 goes down and the chain is then running as Master .. Slave 1 ... Slave 3 ... and so on, when Slave 2 is ready and back on-line, how do we insert it back in the chain so that the chain is back to original and synchronize the data as well)? Thanks a lot in advance, If you can reply to [EMAIL PROTECTED], it would be greatly appreciated. Regards, Amit
CONFIDENTIALITY WARNING This communication, including any attachments, is for the exclusive use of addressee and may contain proprietary and/or confidential information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage exclusif de la personne à laquelle il s’adresse et peut contenir de l’information personnelle ou confidentielle. Si le lecteur de ce message n’en est pas le destinataire, nous l’avisons par la présente que toute diffusion, distribution, reproduction ou utilisation de son contenu est strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier électronique et supprimez ce message ainsi que toutes les pièces jointes.
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
