Re: session_replication_role

Поиск
Список
Период
Сортировка
От Terry Lee Tucker
Тема Re: session_replication_role
Дата
Msg-id 200804151535.13384.terry@chosen-ones.org
обсуждение исходный текст
Ответ на Re: session_replication_role  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-general
On Tuesday 15 April 2008 14:26, Chris Browne wrote:
> 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.
> --

Thanks for the reply. I was unable to detect any change in trigger operation
when setting the variable to origin or local. I understand that you are
saying that the distinction only exists if my code is written to operate
differently based on the setting.

Thanks for the input...
--
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812  Fax: (336) 372-6812  Cell: (336) 404-6987
terry@turbocorp.com
www.turbocorp.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: session_replication_role
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: precompilers