terry@xxxxxxxxxxxxxxx (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@~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/>
