Re: session_replication_role - Mailing list pgsql-general

From Chris Browne
Subject Re: session_replication_role
Date
Msg-id 60k5izug7q.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to session_replication_role  (Terry Lee Tucker <terry@chosen-ones.org>)
Responses Re: session_replication_role  (Terry Lee Tucker <terry@chosen-ones.org>)
List pgsql-general
terry@chosen-ones.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@~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/>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Suggestion for psql command interpretation
Next
From: Terry Lee Tucker
Date:
Subject: Re: session_replication_role