Tue Dec 4 12:13:11 PST 2012
- Previous message: [Slony1-general] Slony version 2.1.0 switchover
- Next message: [Slony1-general] Multiple sets w/same table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony version 2.1.0 switchover
- Next message: [Slony1-general] Multiple sets w/same table
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list