Re: viewing connectioninfo used by subscriber on the publicationserver when inactive

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Дата
Msg-id F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com
обсуждение исходный текст
Ответ на Re: viewing connectioninfo used by subscriber on the publicationserver when inactive  (Keith Fiske <keith.fiske@crunchydata.com>)
Список pgsql-admin
> On May 14, 2020, at 8:34 AM, Keith Fiske <keith.fiske@crunchydata.com> wrote:
>
> But, again, I would still try and rethink this strategy.

For instance:

- single replication slot
- logical decoding locally that filters updates and records the relevant ones into a serialized updates table
- clients record their position in the updates table, ask for new updates on connect

Or, similar to above, but just use triggers on relevant tables.


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

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Следующее
От: Wim Bertels
Дата:
Сообщение: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive