[Bucardo-general] Bucardo Master and loking slave config

David Christensen david at endpoint.com
Mon Oct 5 14:11:10 UTC 2015

> Here I want my replication to be bidirectional for some table an
> unidirectional for other. So I have manage to write a trigger that block all
> the DML for a table but I still need to now if the DML is sent in the local
> client or the distant client in order to decide to run the trigger or not.

The session_replication_role will be set by Bucardo, so if the triggers are defined to be “origin" only that will prevent it from being used when replicating.
David Christensen
PostgreSQL Team Manager
End Point Corporation
david at endpoint.com

More information about the Bucardo-general mailing list