I have the slony 1.24 running on postgres 8.34 I get the following error when i run my slon setup script. I have 3 nodes, 1 replicated to 2 and 2 cascades to 3.
Error <stdin>:23: PGRES_FATAL_ERROR select "_slonytest".subscribeSet(1, 2, 4, 'f'); - ERROR: Slony-I: subscribeSet(): set 1 not found My script slonik <<_EOF_ cluster name = slonytest; node 1 admin conninfo = 'dbname=slonytestdb host=db1.eng.company.net user=pos password=pos123'; node 2 admin conninfo = 'dbname=slonytestdb host=db2.eng.company.net user=pos password=pos123'; node 4 admin conninfo = 'dbname=slonytestdb host=db3.eng.company.net user=pos password=pos123'; init cluster ( id=1, comment = 'Master Node'); store node (id=2, comment = 'Primary Slave node'); store node (id=4, comment = 'Primary query node'); store path (server = 1, client = 2, conninfo='dbname=slontestdb host=db1.eng.company.net user=postgres password=pos123'); store path (server = 2, client = 1, conninfo='dbname=slontestdb host=db2.eng.company.net user=pos password=pos123'); store path (server = 2, client = 4, conninfo='dbname=slontestdb host=db3.eng.company.net user=pos password=postgres1234'); store path (server = 4, client = 2, conninfo='dbname=slontestdb host=db4.eng.company.net user=pos password=pos123'); create set (id=1, origin=1, comment='repl Tables'); set add table (set id=1, origin=1, id=1, fully qualified name = 'moot.users', comment='users table'); subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes); subscribe set ( id = 1, provider = 2, receiver = 4, forward = no); _EOF_ Any insight would be appreciated. If I comment out the last line (subscribing set 1 from 2 to 4 ), it runs without error, so it recognizes set 1 if I don't have the cascaded subscribe. -- View this message in context: http://old.nabble.com/Error-while-trying-to-set-upi-cascaded-slave-tp27380132p27380132.html Sent from the Slony-I -- General mailing list archive at Nabble.com. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
