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