David Rees drees76 at gmail.com
Tue Dec 4 12:13:11 PST 2012
For some reason I thought this was possible, but I'm running into problems.

3 nodes (2 pg 8.4, one 9.0) all running slony 2.1.2.
The same database schema is on all 3 nodes.
Set 1 consists of all tables in the database - node 2 subscribes to
set 1 from node 1.
Set 2 consists of a subset of the tables in the database - node 3
subscribes to set 2 from node 2.

The problem is that when I try to create set 2, slony complains
'ERROR:  duplicate key value violates unique constraint
"sl_table_tab_reloid_key"'

Looking at sl_table_tab_reloid_key it appears that this key would
prevent any single table from being in multiple sets.

In which case, I believe that I could work around this by using a
different cluster for set 2.

Or am I missing something?

Thank you!

Dave


More information about the Slony1-general mailing list