Yi Zhao yi.zhao at alibaba-inc.com
Thu Jul 31 22:10:06 PDT 2008
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
> 



More information about the Slony1-general mailing list