pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Keith Fiske <keith.fiske@crunchydata.com>
Cc: Wim Bertels <wim.bertels@ucll.be>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: viewing connectioninfo used by subscriber on the publication server when inactive
Date: Thu, 14 May 2020 08:40:27 -0600
Message-ID: <F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com> (raw)
In-Reply-To: <CAODZiv5NhMO3dDsDeBm1q6nVvwPnhTuRe7TE7ON3qi+Eha2nfA@mail.gmail.com>
References: <25037dc66dadcdd61148f6d59208217441abfd80.camel@ucll.be>
	<CAODZiv5QMzAd5_ckxMMfxv84Y3YeASX9ePF3k1u1ERnRKgmrEw@mail.gmail.com>
	<5f77a6c973aaf8f9086cf42933f476e5bd9a948d.camel@ucll.be>
	<CAODZiv4LpJ+RfkfesjC91w446hjA3Hhsk_9-TG=cVO8h-0ihLQ@mail.gmail.com>
	<562890eff48a048d4b09d23f76506fceb867a31f.camel@ucll.be>
	<CAODZiv5J2op7t5_P-6gQwKXVefmFXV9WhLPtN159U_PbyyM_jQ@mail.gmail.com>
	<95bb0c6c21a2a96a526a5ce01f16e62ea4f073f5.camel@ucll.be>
	<CAODZiv5NhMO3dDsDeBm1q6nVvwPnhTuRe7TE7ON3qi+Eha2nfA@mail.gmail.com>

> 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.




view thread (12+ messages)  latest in thread

Message-ID: <F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com>
Permalink:  ../F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com/
Also on:    postgresql.org/message-id/F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, keith.fiske@crunchydata.com, wim.bertels@ucll.be
  Subject: Re: viewing connectioninfo used by subscriber on the publication server when inactive
  In-Reply-To: <F3ECB264-D36F-476E-84D9-876ACBB8CF15@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox