Sun Oct 10 21:38:55 PDT 2004
- Previous message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Next message: REPEAT: [Slony1-general] Unable to turn subscription back to forward=false
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi again ;) now I've got the following situation I did some subscription changes (slony 1.0.2, pg 7.4.5) and now I have nodes 1 and 5 both subscribing to master node 2 the replication is happening, but both 1 and 5 ended up with subscription option forward = yes userdb=# select * from _userdb_cluster.sl_subscribe ; sub_set | sub_provider | sub_receiver | sub_forward | sub_active ---------+--------------+--------------+-------------+------------ 1 | 2 | 5 | t | t 1 | 2 | 1 | t | t (2 rows) resulting in _sl_log_1 with ~3M rows I want to stop them from forwarding, but a slonik script, that should do it ... subscribe set ( id = 1, provider = 2, receiver = 1, forward = no); subscribe set ( id = 1, provider = 2, receiver = 5, forward = no); just runs silently to completion with no effect What am I doing wrong/ what are my options can I just set sub_forward=false and restart slon's ? -------------- Hannu
- Previous message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Next message: REPEAT: [Slony1-general] Unable to turn subscription back to forward=false
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list