Hi All,
 
I have replicated two tables customer, customer data on to test_slave database from test database. I am trying to add two more tables to be replicated with the following script.
 
#!/bin/sh
slonik <<_EOF_
        #--
    # define the namespace the replication system uses in our example it is
    # slony_example
        #--
        cluster name = $CLUSTERNAME;
        #--
        node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$TESTDBUSER';
        node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER';
        echo 'nodes setup';
        #--
        drop set (id=3, origin=1);
        echo 'dropped set if existing already';
        create set (id=3, origin=1, comment='Some tables 3');
        echo 'created new set';
        set add table (set id=3, origin=1, id=3, fully qualified name = 'public.table1', comment=' table1');
        set add table (set id=3, origin=1, id=4, fully qualified name = 'public.table2', comment='table2');
        echo 'added tables to replicate';
        subscribe set (id = 3, provider = 1, receiver = 2, forward = no);
        merge set (id=1, add id = 3, origin=1);
        echo 'merged sets';
        subscribe set (id = 1, provider = 1, receiver = 2, forward = no);

        store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST user=$TESTDBUSER');
        store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST user=$REPLICATIONUSER');
        store listen (origin=1, provider = 1, receiver =2);
        store listen (origin=2, provider = 2, receiver =1);
_EOF_

 
When I execute this script, I get the following error:
<stdin>:10: nodes setup
<stdin>:14: dropped set if existing already
<stdin>:16: created new set
<stdin>:19: added tables to replicate
<stdin>:20: PGRES_FATAL_ERROR select "_ikobo_test".subscribeSet(3, 1, 2, 'f');  - ERROR:  Slony-I: set 3 not found

 
Why is it not able to find the set that was created? Am I missing on something else?
 
Thanks,
Saranya
 
 

		
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - You care about security. So do we.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050103/499aab5f/attachment.html