Yi Zhao yi.zhao at alibaba-inc.com
Mon Jul 21 04:45:29 PDT 2008
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')"



More information about the Slony1-general mailing list