Re: Logical decoding

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: Jethish Jethish <jethish777(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Logical decoding
Date: 2025-02-20 09:27:17
Message-ID: 1c759cc7-0db5-4249-9b65-43d824a79903@vondra.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-02-20 09:33:38 Re: ERROR: stack depth limit exceeded
Previous Message richard 2025-02-20 07:55:31 Re: In-place upgrade with streaming replicas