Thu Jul 31 20:11:14 PDT 2008
- Previous message: [Slony1-general] Strange thing happens after switchover
- Next message: [Slony1-general] after I initialize a set, can I add other table to it again?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] Strange thing happens after switchover
- Next message: [Slony1-general] after I initialize a set, can I add other table to it again?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list