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 ammarya at symcor.com, it would be greatly appreciated.

Regards,

Amit

-------------- next part --------------


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.