Sven Willenberger sven
Fri Jan 13 12:25:31 PST 2006
Slony 1.1.2 on FreeBSD 5.x and PostgreSQL 8.0.3

I have 3 servers, let's call them server1 server2 server3.

Currently I have a situation that resembles:

server2 [origin] --> Set 1 [tableA tableB tableC] --> server3
server2 [origin] --> Set 2 [tableD tableE] --> server1

What I now have need of is for tableB to also replicate to server1.
Since tableB is part of Set 1 I tried to create a new set (3) and add
tableB to it. This of course bails with due to a failed unique key
constraint being met (that of table_reloid).

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?

Sven




More information about the Slony1-general mailing list