Wed Aug 13 06:48:32 PDT 2008
- Previous message: [Slony1-general] how to add a table which have unique(too column) into slony?
- Next message: [Slony1-general] why my slony became invalidation?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I have a replaction cluster which works well someday ago: when I insert a record into master, the slave will get the record. today, I want to add some other table into it, so I create a new set like this: #!/bin/bash SLONIK=/usr/local/pgsql/bin/slonik $SLONIK <<_SCRIPT_ cluster name = replication; node 1 admin conninfo='host=localhost dbname=bbs user=ya port=5432'; node 2 admin conninfo='host=localhost dbname=bbs user=ya port=5433'; node 3 admin conninfo='host=localhost dnname=bbs user=ya port=5434'; try { create set (id = 2, origin = 1, comment = 'Set 2 for replication'); } on error { echo 'Could not create subscription set 2 for replication'; exit -1; } echo 'Subscription set 2 created'; echo 'Adding tables to subscription set'; set add table (set id = 2, origin = 1, id = 523, full qualified name = 'content.thread_preference', comment = 'nodesc'); try { subscribe set (id=2, provider=1, receiver=2, forward=yes); subscribe set (id=2, provider=1, receiver=3, forward=yes); } on error { echo 'Could not create subscribe and merge for replication'; exit -1; } _SCRIPT_ but, when the set created, I found that slony became invalidation, for example, when I delete/insert a record from master, there is no affect to slave. (all the trigger created by slony is exist) I don't know what's wrong with it? I can't get any information from the slony's log. can someone tell me what I should do with it??? thanks very much. regards. Yi
- Previous message: [Slony1-general] how to add a table which have unique(too column) into slony?
- Next message: [Slony1-general] why my slony became invalidation?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list