Re: session_replication_role

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: session_replication_role
Дата
Msg-id 60k5izug7q.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на session_replication_role  (Terry Lee Tucker <terry@chosen-ones.org>)
Ответы Re: session_replication_role
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Suggestion for psql command interpretation
Следующее
От: Terry Lee Tucker
Дата:
Сообщение: Re: session_replication_role