Mon Jul 21 04:45:29 PDT 2008
- Previous message: [Slony1-general] Node not found in the runtime configuration
- Next message: [Slony1-general] Node not found in the runtime configuration
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
hi, all: after I adding some table which has primary key to slony set, I use command '\d test_table' on the slave database, but......I can't find the trigger as below: "Triggers: _replication_denyaccess_2 BEFORE INSERT OR DELETE OR UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE _replication.denyaccess('_replication')" I got above trigger description from another exists slony replication, but, I don't know why I can't find it from my replication:( I create the slony repliation set by slony-tools as below: -------------------------------------------------- #!/bin/bash #initialize slony /usr/local/slony-i/slonik_init_cluster | /usr/local/pgsql/bin/slonik #start slon daemon /usr/local/slony-i/slon_start 1 /usr/local/slony-i/slon_start 2 #create replication set /usr/local/slony-i/slonik_create_set 1 | /usr/local/pgsql/bin/slonik #add master and it's slave /usr/local/slony-i/slonik_subscribe_set 1 2 | /usr/local/pgsql/bin/slonik -------------------------------------------------- ps: I can find trigger added by slony from master database as " _replication_logtrigger_5 AFTER INSERT OR DELETE OR UPDATE ON content.thread_2 FOR EACH ROW EXECUTE PROCEDURE _replication.logtrigger('_replication', '5', 'kvvvvvvvvvvvvvvvvvvvvv vv')"
- Previous message: [Slony1-general] Node not found in the runtime configuration
- Next message: [Slony1-general] Node not found in the runtime configuration
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list