Slony1 PostgreSQL Replication - Replicating a table over 2 different subsriber sets

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Replicating a table over 2 different subsriber sets

Sven Willenberger

2006-01-13, 8:24 pm

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

Sponsored Links