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 по дате отправления: