logtrigger/denyaccess triggers removed from master/slave
От
tamanna madaan
Тема
logtrigger/denyaccess triggers removed from master/slave
Дата
Msg-id
68666423656E1444A011106C4E085F4D96F090@ex3-del1.synapse.com
Список
Дерево обсуждения
logtrigger/denyaccess triggers removed from master/slave "tamanna madaan" <tamanna.madan@globallogic.com>
Re: logtrigger/denyaccess triggers removed from master/slave Greg Stark <gsstark@mit.edu>
Re: logtrigger/denyaccess triggers removed from
master/slave Tamanna <er_tamanna@yahoo.com>
Hi All
I am using postgres-8.1.2 and slony-1.1.5 for replication.
I have 1 master and 1 slave in my cluster.
Sometimes I see problem of missing logtriggers and denyaccess triggers
on master table and slave tables respectively. Replication don't take place in that
state though systems are properly shown as master and slave.
This problem is resolved by dropping the schema used by slony on both the systems an
then recreating the schema.
I want to know what could be the root cause of logtriggers/denyaccess
triggers getting removed from the tables.
Thanks in advance
Regards
Tamanna
В списке pgsql-general по дате отправления