Yi Zhao yi.zhao at alibaba-inc.com
Thu Jul 31 20:11:14 PDT 2008
hi, all:
I have create a slony set for replication and it works well. but, I
found that I forgot to add some table, so i want to add this table to
it, I create this script named 1.slon:

cluster name = replication;
 node 1 admin conninfo='host=localhost dbname=bbs user=yahoo port=5432';
 node 2 admin conninfo='host=db40.bbs.cnb dbname=bbs user=yahoo
port=5433';
 node 3 admin conninfo='host=db40.bbs.cnb dbname=bbs user=yahoo
port=5434';

# ADD TABLE 
  try {
    SET ADD TABLE (set id = 1, origin = 1, id = 1, fully qualified name
= 'content.thread_preference', comment = 'nodesc');
  } on error {
    echo 'Could not add table content.thread_preference for
replication!';
    exit -1;
  }
------------
but, when I do this: cat 1.slon | /usr/local/pgsql/bin/slonik, I got:
<stdin>:7: PGRES_FATAL_ERROR select "_replication".setAddTable(1, 1,
'content.thread_preference', 'thread_treference_pkey', 'nodesc');  -
ERROR:  Slony-I: cannot add table to currently subscribed set 1
<stdin>:9: Could not add table content.thread_preference for
replication!

what's wrong with it?

any help is appreciated.
thanks.




More information about the Slony1-general mailing list