[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Copy function for logical replication slots
From:       Michael Paquier <michael () paquier ! xyz>
Date:       2018-06-28 3:29:11
Message-ID: 20180628032911.GG11054 () paquier ! xyz
[Download RAW message or body]


On Thu, Jun 28, 2018 at 11:51:20AM +0900, Masahiko Sawada wrote:
> A use case I imagined is for investigations for example. I mean that
> when replication collision occurs on subscriber there is no way to see
> what replicated data is conflicting (perhaps error log helps it but is
> not detailed) and there is no way to advance a replication origin in
> order to exactly skip to apply conflicting data. By creating a new
> logical slot with a different output plugin at the same LSN, we can
> see what data a replication slot will decode (and send) and those LSNs
> as well. This function will help for that purpose.

Hm.  Shouldn't the original slot copied be owned by the process doing
the copy with ReplicationSlotAcquire?  There could be some cases where
copying a physical slot also makes sense.
--
Michael

["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]