Re: Skipping logical replication transactions on subscriber side

Поиск
Список
Период
Сортировка
От Mark Dilger
Тема Re: Skipping logical replication transactions on subscriber side
Дата
Msg-id B34971FD-310B-47F0-948C-B9E4399538EC@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Skipping logical replication transactions on subscriber side  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: Skipping logical replication transactions on subscriber side  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers

> On Aug 30, 2021, at 12:06 AM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> I've attached rebased patches.

Thanks for these patches, Sawada-san!

The first patch in your series, v12-0001, seems useful to me even before committing any of the rest.  I would like to
integratethe new pg_stat_subscription_errors view it creates into regression tests for other logical replication
featuresunder development. 

In particular, it can be hard to write TAP tests that need to wait for subscriptions to catch up or fail.  With your
viewcommitted, a new PostgresNode function to wait for catchup or for failure can be added, and then developers of
differentprojects can all use that.  I am attaching a version of such a function, plus some tests of your patch (since
itdoes not appear to have any).  Would you mind reviewing these and giving comments or including them in your next
patchversion? 


—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




Вложения

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

Предыдущее
От: Paul Martinez
Дата:
Сообщение: Re: [PATCH] Partial foreign key updates in referential integrity triggers
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: Skipping logical replication transactions on subscriber side