Re: [HACKERS] Function to move the position of a replication slot

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Function to move the position of a replication slot
Дата
Msg-id CA+TgmobdKSWxibPvYq-mL93pggNvEda78T_12eLGppm3X=H1KA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Function to move the position of a replication slot  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] Function to move the position of a replication slot  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Fri, Sep 1, 2017 at 11:30 PM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> On 8/31/17 08:19, Magnus Hagander wrote:
>> Rebased. Now named pg_advance_replication_slot. ERROR on logical slots.
>> Forward only.
>>
>> I think that, in the end, covered all the comments?
>
> I didn't see any explanation of what this would actually be useful for.
> I suppose you could skip over some changes you don't want replicated,
> but how do you find to what position to skip?
>
> Logical replication has a similar mechanism, using the function
> pg_replication_origin_advance().  Any overlap there?  (Maybe the names
> could be aligned.)
> (https://www.postgresql.org/docs/devel/static/logical-replication-conflicts.html)

I think you can use this to work around the absence of failover slots.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: [HACKERS] adding the commit to a patch's thread
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Parallel worker error