On 2/20/25 06:04, Jethish Jethish wrote:
> Hi everyone,
>
> Is there is any option to perform logical decoding on an active
> replication slot.
> I'm trying to decode a replication slot but it throughs an error as below.
>
> ERROR: replication slot "my_sub" is active for PID 2525720
No, not really. The whole point of this error is to prevent exactly
this, pretty much - to only allow a single process doing logical
decoding on a slot.
What are you trying to solve / achieve? Why do you need (or think you
need) logical decoding on an active slot?
regards
--
Tomas Vondra