Mon Oct 11 05:26:09 PDT 2004
- Previous message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Next message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> My questions are: a) Where am I going wrong ? What is wrong is that you need a much fuller set of paths and listen settings. If there are 3 nodes, the paths and listener settings need to look more like the following: cluster name = transtest; node 1 admin conninfo='host=host1 dbname=transtest user=postgres port=5432 password=postgres'; node 2 admin conninfo='host=host2 dbname=transtest user=postgres port=5432 password=postgres'; node 3 admin conninfo='host=host3 dbname=transtest user=postgres port=5432 password=postgres'; store path (server = 1, client = 2, conninfo = 'host=host1 dbname=transtest user=postgres port=5432 password=postgres'); store path (server = 2, client = 1, conninfo = 'host=host2 dbname=transtest user=postgres port=5432 password=postgres'); store path (server = 1, client = 3, conninfo = 'host=host1 dbname=transtest user=postgres port=5432 password=postgres'); store path (server = 3, client = 1, conninfo = 'host=host3 dbname=transtest user=postgres port=5432 password=postgres'); store path (server = 2, client = 3, conninfo = 'host=host2 dbname=transtest user=postgres port=5432 password=postgres'); store path (server = 3, client = 2, conninfo = 'host=host3 dbname=transtest user=postgres port=5432 password=postgres'); ## and listeners... store listen (origin = 1, receiver = 2, provider = 1); store listen (origin = 1, receiver = 3, provider = 1); store listen (origin = 2, receiver = 1, provider = 2); store listen (origin = 2, receiver = 3, provider = 1); store listen (origin = 3, receiver = 1, provider = 3); store listen (origin = 3, receiver = 2, provider = 1); You're missing the communications between nodes 2 and 3, and that's probably what has gone wrong. If you take a look at the tables sl_path and sl_listen, on all three nodes, you'll probably find that instead of having 6 entries in each table (which is what you need), node 1 only has 4, and nodes 2 and 3 may only have 2. There should be 6 in each. Even though nodes 2 and 3 aren't directly speaking, they still need to be on "speaking terms" in order that SYNCs make it back and forth so all the nodes can know when to purge out sl_log_? entries. Revise the paths and listens and see if that takes you some steps ahead...
- Previous message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Next message: [Slony1-general] 1-Master->2-Slaves replication help needed
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list