>(since one can't add a table to an existing replication set)

That is not true at all.

The following slony commands allow you to add a table to an existing set;

slonik <<_EOF_

CLUSTER NAME = $YOUR_CLUSTER;

node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER';
node 101 admin conninfo = 'dbname=$MASTERDBNAME host=$SLAVEHOST1 port=$PGPORT user=$REPLICATIONUSER';

#CREATE NEW TEMP SET
CREATE SET ( ID=999, ORIGIN = 1, COMMENT = 'Temporary new set' );

#Add the table(s) and/or sequence(s) to the new temp set

SET ADD TABLE (SET ID=999, ORIGIN=1, ID=107, FULLY QUALIFIED NAME='you_schema.you_table', comment='your_table comment') ;
SET ADD TABLE (SET ID=999, ORIGIN=1, ID=110, FULLY QUALIFIED NAME='pts_meta.master_project', comment='master_project') ;


#Subscribe the slave(s) to the new set
SUBSCRIBE SET ( ID = 999, PROVIDER = 1, RECEIVER = 101, FORWARD = NO );

#Need to wait for 101 to confirm before continuing
WAIT FOR EVENT (ORIGIN=1, CONFIRMED=101);

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

_EOF_

Melvin Davidson 
  


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110214/7ece2420/attachment.htm