On Thu, Nov 19, 2015 at 5:48 PM, konstantin knizhnik
> I want to use logical replication for implementing multimaster (so all nodes
> are both sending and receiving changes).
> But there is one "stupid" problem: how to prevent infinite recursion and not
> to rereplicate replicated data.
> I.e. node receives change set from some other node, applies it within some
> transaction, it is written to the log and ... is replicated to other nodes.
> In my experiments with receiver_raw/decoder_raw infinite recursion actually
> doesn't happen because unique constraint violation.
> But it is neither nice, neither efficient way of stopping infinite recursion.
> I wonder if there is some better way to prevent some particular transaction
> from been replicated?
What you are looking for to prevent this infinite recursion is the
concept of replication origin:
Regarding receiver_raw/decoder_raw, I never got around to use that and
prevent the problem you are seeing :) But patches are welcome if
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: