On Fri, 2006-01-13 at 12:31 -0800, Alan Hodgson wrote: > On January 13, 2006 12:25 pm, Sven Willenberger <[EMAIL PROTECTED]> wrote: > > So my question is whether there is any way to add tableB such that it > > now replicates from server2 to server1? Or is it possible to change the > > subcription definition of server3 to set FORWARD = yes and could I then > > set up replication from server3 to server1 as follows: > > > > server3 [origin] --> Set 3 [tableB] --> server1 > > > > Or will I still fail due to the table_reloid constraint? > > You need to move the table to a third set that is replicated to the > necessary servers. >
I came to the same conclusion about 5 minutes after I sent the email. I ended up dropping replication of the table and sequence, created a new set that had the one server as origin and the other 2 as subscribers, added the table and sequence to this new set and started subscribed the nodes. All worked well :-) Thanks, Sven _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
