Re: Logical decoding

On Thu, Feb 20, 2025 at 12:04 AM 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

Re: Logical decoding

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"

Logical decoding

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

Logical decoding plus streaming replication fail-over

Hello, Did anybody solve a problem of logical replication slot fail-over on a streaming replication cluster? I have a logical decoding on a logical replication slot set up on a streaming replication master. Streaming replication does not propagate the replication slot state. In case of fail-over

Log level of logical decoding

of messages like 2018-11-30 10:37:29 UTC LOG: starting logical decoding for slot "test_slot" 2018-11-30 10:37:29 UTC DETAIL: streaming transactions committing after 4AC/41D5F950, reading WAL from 4AC/41C16868 2018-11-30 10:37:29 UTC STATEMENT: SEL

Streaming Logical Decoding Events

Hi there, I am trying to build an application which reads messages off of a replication slot and does some processing with them. I want to guarantee that every event gets processed exactly once. Unfortunately, I've been unable to find a guide to the correct way to read this data. I've been expe

Re: Logical decoding on standby

Am 13.03.2018 um 02:40 schrieb Andres Freund: The subject said logical decoding, not replication. There's a lot of change data capture type workloads where decoding from the standby is quite useful. And the design definitely would work for that, we've explicitly took that into con

Re: Logical decoding on standby

ning for v11, there's not even a CF entry in the last CF. > >Why do you think you needs this? > > > >Regards, Andreas > > Let me explain my question. One of the key aspects of logical replication is, > that you can define what to replicate. That wouldn't

Sv: Re: Logical decoding on standby

På tirsdag 13. mars 2018 kl. 01:08:03, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: On 13 March 2018 00:58:27 CET, Andreas Kretschmer wrote: >On 12 March 2018 21:18:22 CET, Andreas Joseph Krogh > wrote: >>Anybody knows if $subject will make it into v11?

Re: Logical decoding on standby

On Mon, Mar 12, 2018 at 5:08 PM, Andreas Kretschmer wrote: > Let me explain my question. One of the key aspects of logical replication > is, that you can define what to replicate. That wouldn't work in this way, > that's why i'm asking. One of the key aspects of "standby" is that it is ready to

Re: Logical decoding on standby

On 13 March 2018 00:58:27 CET, Andreas Kretschmer wrote: >On 12 March 2018 21:18:22 CET, Andreas Joseph Krogh > wrote: >>Anybody knows if $subject will make it into v11? >>  >>-- >>Andreas Joseph Krogh > >Why do you think you needs this? > >Regards, Andreas Let me explain my question. One of th

Re: Logical decoding on standby

On 12 March 2018 21:18:22 CET, Andreas Joseph Krogh wrote: >Anybody knows if $subject will make it into v11? >  >-- >Andreas Joseph Krogh Why do you think you needs this? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company

Logical decoding on standby

Anybody knows if $subject will make it into v11?   -- Andreas Joseph Krogh

Re: Critical errors during logical decoding

On 02/07/2018 10:22 PM, Colin Morelli wrote: > Hey Tomas, > > We're using v1.1.0 of pglogical. I can't honestly say what could > reproduce this issue as I'm not entirely sure and haven't tested it yet. > Well, consider updating - there's 1.1.2 in that exact branch, and there's also 2.1.1 now.

Re: Critical errors during logical decoding

Hey Tomas, We're using v1.1.0 of pglogical. I can't honestly say what could reproduce this issue as I'm not entirely sure and haven't tested it yet. I had thought it was caused when a toasted row is deleted before the pglogical_output plugin processes the event (so it fails when going to de-toast

Re: Critical errors during logical decoding

On 02/07/2018 09:07 PM, Colin Morelli wrote: > Appears to be a problem with pglogical_output when de-toasting columns. > Switched to wal2json and the problem went away. I believe I may have > found the issue anyway. Apologies for the noise. > What pglogical version are you using? Can you share an

Re: Critical errors during logical decoding

uot; > '1') > 2018-02-07 19:14:31 UTC [3985-2] svc_app@app LOCATION: > exec_replication_command, walsender.c:1341 > 2018-02-07 19:14:31 UTC [3985-3] svc_app@app LOG: 0: starting > logical decoding for slot "event_stream" > 2018-02-07 19:14:31 UTC [3985-4

Critical errors during logical decoding

#x27;1') 2018-02-07 19:14:31 UTC [3985-2] svc_app@app LOCATION: exec_replication_command, walsender.c:1341 2018-02-07 19:14:31 UTC [3985-3] svc_app@app LOG: 0: starting logical decoding for slot "event_stream" 2018-02-07 19:14:31 UTC [3985-4] svc_app@app DETAI