On 6/19/2012 12:43 PM, Efraín Déctor wrote:
> Hello.
> We want to use Slony to keep our 2 servers replicated, however several
> tables are being accesed by Java processes that perform updates on them,
> Slony doesn’t this allow to happen. Is there a way to allow this?.
> Thank you.

Several ways.

1) The proper way to do this would be to those fields, that need to be 
updated on the replica, into separate tables that are not replicated and 
local to the replica.

2) You could move the code, that modifies those rows, into a BEFORE 
trigger and configure it on the replica so that it fires during replication.

3) You could disable the deny_access triggers on those tables.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin