"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Mon May 5 08:38:09 PDT 2008
Hi,

I put up a replication composed of 2 sets, each one subscribed by different nodes.

(that is I have 5 nodes, 2 sets

First set is replicating that way :
1 -> 2 -> 3 -> 4
     \-> 5

Second set :
4 -> 3 -> 2 -> 1)

First, I wonder which set the information given by sl_status on different nodes
refers to, and how I could get relevant information about each replicated set.

Second, if I have to failover node 1 or node 4, how would I have to proceed?

Would it be enough to fail from 1 to 2 and drop node 1? (It seems indeed that
patched 1.2.14 version works that way, but I'd prefer be sure.)

Best regards,
-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
Tél. 09 53 69 97 12
http://www.postgresql.fr


More information about the Slony1-general mailing list