Fri Jan 13 12:25:31 PST 2006
- Previous message: [Slony1-general] "Intro" document
- Next message: [Slony1-general] Replicating a table over 2 different subsriber sets
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] "Intro" document
- Next message: [Slony1-general] Replicating a table over 2 different subsriber sets
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list