Marc G. Fournier marc
Mon Feb 27 18:46:53 PST 2006
Looking at http://linuxfinances.info/info/addthings.html, I'm wondering if 
someone has an example slonik script that would add one table to an 
existing set, where one is dealing with a single slave?

Is it as simple as:

slonik <<_EOF_
   CREATE SET ( ID = 999, ORIGIN = 1, COMMENT = 'Add New Table' );

   SET ADD TABLE (
         SET ID = 999,
         ORIGIN = 1,
         ID = 20,
         FULLY QUALIFIED NAME = 'public.newtable',
         COMMENT = 'New Table To Add'
     );

   SUBSCRIBE SET (
        ID = 999,
        PROVIDER = 1,
        RECEIVER = 2,
        FORWARD = YES
     );

   MERGE SET ( ID = 1,
          ADD ID = 9999,
          ORIGIN = 1 );

_EOF_

Now, I'm guessing right now, but PROVIDER/RECEIVER can "reuse" the ones 
that are already defined as part of the original replication set, I don't 
need to create new ones just for the temporary set, do I?

Also, is there a way in slonik of telling SET ADD TABLE to use the next 
available ID, or do I have to query the sl_table for 'max(tab_id) + 1' 
before I setup the script?

And, finally, I hope ... MERGE SET automatically gets rid of the TEMP SET 
that I'm creating for this purpose, or do I need to remove that after its 
MERGEd?

Thanks ...




More information about the Slony1-general mailing list