Thu Jul 31 22:10:06 PDT 2008
- Previous message: [Slony1-general] after I initialize a set, can I add other table to it again?
- Next message: [Slony1-general] after I initialize a set, can I add other table to it again?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
when I merge: I got, <stdin>:13: Subscription set 2 created <stdin>:14: Adding tables to subscription set <stdin>:18: PGRES_FATAL_ERROR select "_replication".mergeSet(1, 2); - ERROR: Slony-I: subscriber lists of set 1 and 2 are different :D On Thu, 2008-07-31 at 20:19 -0700, Jeff Frost wrote: > On Fri, 1 Aug 2008, Yi Zhao wrote: > > > ------------ > > 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? > > That's because slony doesn't allow you to directly add tables to a subscribed > set. You have to create a new temporary set, add the table(s) and sequence(s) > to this new set, subscribe the set to the same nodes as the original set, then > merge the set. See the "12.1. Adding a table to replication" section of > the docs here: > > http://www.slony.info/documentation/addthings.html >
- Previous message: [Slony1-general] after I initialize a set, can I add other table to it again?
- 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