pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chandy G <vgchandru@yahoo.com>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Subject: Re: Toasted column values during replication
Date: Sat, 15 Jul 2023 20:42:56 +0000 (UTC)
Message-ID: <1225296747.546374.1689453776431@mail.yahoo.com> (raw)
In-Reply-To: <4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at>
References: <676545357.616656.1688144798077.ref@mail.yahoo.com>
	<676545357.616656.1688144798077@mail.yahoo.com>
	<4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at>

 Using pgoutput - aws rds 13* version and seeing this behavior when using it with debezium 2.0.0 version.
Best.


    On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe <laurenz.albe@cybertec.at> wrote:  
 
 On Fri, 2023-06-30 at 17:06 +0000, Chandy G wrote:
> For instance :  Can the postgres internal component (wal-sender / *) interpret this special
> toasted-col-value sitting in the wal-file -> replace it with the actual value and send it to
> the replication slot.

Which logical decoding plugin are you using?

"pgoutput", which is provided by PostgreSQL, will surely emit properly detoasted values.

Yours,
Laurenz Albe


  

view thread (3+ messages)

Message-ID: <1225296747.546374.1689453776431@mail.yahoo.com>
Permalink:  ../1225296747.546374.1689453776431@mail.yahoo.com/
Also on:    postgresql.org/message-id/1225296747.546374.1689453776431@mail.yahoo.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: vgchandru@yahoo.com, laurenz.albe@cybertec.at
  Subject: Re: Toasted column values during replication
  In-Reply-To: <1225296747.546374.1689453776431@mail.yahoo.com>
  References: <676545357.616656.1688144798077.ref@mail.yahoo.com> <676545357.616656.1688144798077@mail.yahoo.com> <4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at> <1225296747.546374.1689453776431@mail.yahoo.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