Re: viewing connectioninfo used by subscriber on the publicationserver when inactive - Mailing list pgsql-admin

From Scott Ribe
Subject Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Date
Msg-id F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com
Whole thread Raw
In response to Re: viewing connectioninfo used by subscriber on the publicationserver when inactive  (Keith Fiske <keith.fiske@crunchydata.com>)
List 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 by date:

Previous
From: Keith Fiske
Date:
Subject: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Next
From: Wim Bertels
Date:
Subject: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive