Re: session_replication_role

terry(at)chosen-ones(dot)org (Terry Lee Tucker) writes:
> Is there a distinction between "ORIGIN" and "LOCAL" as related to
> session_replication_role, and if so, what is it? I am unable to understand
> from the documentation any distinction between the two settings.

The intent is that a system that is the "origin" for replication
changes (e.g. - a database where you'll be collecting
INSERT/UPDATE/DELETE information to replicate elsewhere) would run in
the "origin" role, normally.

The distinction from a practical perspective will take place when
stored functions that implement "replication stuff" detect what role
the system is in, and may behave differently.
--
(format nil "~S(at)~S" "cbbrowne" "acm.org")
http://linuxdatabases.info/info/multiplexor.html
Rules of the Evil Overlord #7. "When I've captured my adversary and he
says, "Look, before you kill me, will you at least tell me what this
is all about?" I'll say, "No." and shoot him. No, on second thought
I'll shoot him then say "No."" <http://www.eviloverlord.com/>