Re: How to find local logical replication origin?

Hi,

On 10/09/18 05:30, Jinhua Luo wrote:
> Because I found in the source codes that if not explicitly set (e.g.
> via pg_replication_origin_session_setup), the
> replorigin_session_origin included in the wal is InvalidRepOriginId,
> correct?

This is correct, unless explicitly set, it will be InvalidRepOriginId.

> Jinhua Luo <luajit(dot)io(at)gmail(dot)com> 于2018年9月9日周日 下午10:16写道：
>>
>> Could I assume all local originated changes is with InvalidRepOriginId?
>> Jinhua Luo <luajit(dot)io(at)gmail(dot)com> 于2018年9月8日周六 下午5:41写道：
>>>
>>> Hi All,
>>>
>>> What's the local logical replication origin, which could be used to
>>> filter local changes in the replication slot?
>>>
>>> In other words, I'm curious that what's the default replication
>>> origin? Because normal DML locally does not set any origin explicitly,
>>> correct?
>

--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services