Hi ,
I have a replication consisting of 6 nodes.
N1 is master, N3 and N5 are directly connected to N1. N6 is connected to
N5 and N4 to N3.
That gives me:
test2=# select * from _instance3.sl_subscribe ;
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
1 | 1 | 3 | t | t
1 | 1 | 5 | t | t
1 | 3 | 4 | t | t
1 | 5 | 6 | t | t
(4 lignes)
For maintenance purpose, for instance, I'd like to switch N1 and N3. I
was wondering it would give me something like :
3->1
3->5
3->4
5->6
But I then obtain :
test2=# select * from _instance3.sl_subscribe ;
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
1 | 1 | 5 | t | t
1 | 3 | 4 | t | t
1 | 5 | 6 | t | t
1 | 3 | 1 | t | t
(4 lignes)
I thought the move set would have switched N1 and N3 for all nodes
directly subscribed to N1.
As I am actually wrong, what should I do in order to really move all
sets to the new master ?
Regards,
SAS
--
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
06 13 60 37 44 - 09 53 69 97 12
http://www.PostgreSQLFr.org
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
