Thu Nov 18 19:12:26 PST 2004
- Previous message: [Slony1-general] 1.0.6 patches?
- Next message: [Slony1-general] creating new set doesnt work after switchover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, Here are the sequence of the events I tried. Node 1 (Master) Node 2 (Slave) Slony 1.0.5 Postgresql 8 Beta 4 1) Setup Replication between Master and Slave (works fine) 2) Ran Failover and Drop Node commands on Slave (works fine) 3) Tried to make Node 1 as Master now, rebuilt Node 1 , dropped slony cluster schema on Node 2 , ran initialization script on Node 2 which is master now , started replication daemons both on master and slave, ran subscribe script on Node 2 (master) (works fine) 4) Ran Switchover script on Node 2 which is master now (works fine) 5) Node 1 is Master and Node 2 is slave now after the switchover , tried to add a new table to the replication set . so, created the new table manually thru psql on Node 1 and Node 2. ran the create new set script on Node 1 (works fine) --> New Set Script attached 6) Ran the subscribe script for the new set on Node 1 (FAILS) with the following error : <stdin>:18: PGRES_FATAL_ERROR select "_slony_example_usa".subscribeSet(6, 1, 2, 'f'); - ERROR: Slony-I: subscribeSet() must be called on receiver --> Subscribe script attached Why should I call this on receiver ? before failover i used to same procedure to add a new set and it worked fine. Can any one please tell me what am I missing here or is this somekind of bug ? Thanks! a lot Pallav -------------- next part -------------- A non-text attachment was scrubbed... Name: slony_setup_create_newset6.sh Type: application/x-sh Size: 920 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20041118/292662b2/slony_setup_create_newset6.sh -------------- next part -------------- A non-text attachment was scrubbed... Name: slony_subscribe_newset6.sh Type: application/x-sh Size: 699 bytes Desc: not available Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20041118/292662b2/slony_subscribe_newset6.sh
- Previous message: [Slony1-general] 1.0.6 patches?
- Next message: [Slony1-general] creating new set doesnt work after switchover
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list